SQL INNER JOIN on two CSV files

Channel:
United Kingdom Geb Systems
Subscribers:
567
Published on ● Video Link: https://www.youtube.com/watch?v=eSj8jL6xdOA


Duration: 3:35
144 views
3

The world could not get any weirder... For some reason it is possible to execute a join query on two CSV files with the help of ODBC via PHP. Who knew?!

This introduces interesting possibilities because unlike XLS files you can open the CSV file with a text editor and still be able to run queries on them. However I think that I would still go with XLS files despite this little inconvenience. Sharing this as I was just AMUSED into the HIGH HEAVENS!



Other Videos By Geb Systems


2022-08-15Suriouc: Suggestions on the roadmap
2022-08-12Suriouc: Excel2Web getting closer
2022-08-06Constructor: Excel to Web & SQL Schema?
2022-07-31Web Interface over Excel file
2022-07-25SQLite vs Excel for STD as database
2022-07-19Smiling Troll Distillery Limited (Incorporated)
2022-07-17DIY Intranet: CSV2SQLITE Tool
2022-07-14Basic DIY Intranet: Simple Barcode Generation Demo
2022-07-12Arduino Mp3 Player... 2nd UPDATE
2022-07-10Basic DIY Intranet: Going deeper
2022-07-09SQL INNER JOIN on two CSV files
2022-07-07Basic DIY Intranet: Read from Excel files
2022-07-05Basic DIY Intranet: Web Server (XAMPP)
2022-07-05Basic DIY Intranet Part 2: Database Connect Function
2022-07-03Din rail for Arduino Projects
2022-07-02Basic Introduction to a DIY PHP Intranet + Code
2022-06-18RS485 and TCPIP at the same time over RJ45
2022-06-17RS485 toplogy fun with four RJ45 splitters
2022-06-12RJ45 splitter used for a DIY modbus "network"
2022-06-10Arduino Modbus using Din Terminal Blocks
2022-06-03Arduino ModBus: Ethernet Cable Splitter


Tags:
php
intranet
sql
csv inner join