The easiest way to convert an Excel table to MySQL is to dump the table to CSV format, then use LOAD DATA INFILE
to load it into a MySQL table. The syntax for loading a CSV file is as follows:
LOAD DATA INFILE 'data.csv' INTO TABLE tbl_name FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';Full information on LOAD DATA INFILE can be found at http://dev.mysql.com/doc/mysql/en/load-data.html.
Dig deeper on Open source databases
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.