Import an Excel, CSV, txt file into MySQL

Import an Excel, CSV, TXT file into MySQL


LOAD DATA LOCAL INFILE 'C:\\temp\\ListOfCountries.csv'
INTO TABLE [Table Name]
FIELDS TERMINATED BY ''
LINES TERMINATED BY '\r\n'
([Field1],[Field2]);

No comments:

Post a Comment

Keep ur coding aside.. Relax for some time..