How to import excel file into MySQL Database via PHPMyadmin?
LOAD DATA LOCAL INFILE '/importfile.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
Labels: csv file, excel file, import, import database, mysql, phpmyadmin
LOAD DATA LOCAL INFILE '/importfile.csv'
Labels: csv file, excel file, import, import database, mysql, phpmyadmin
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home