MySQL: Load data into table from file
The following piece of code shows how you can load data from a comma separated values file directly into a MySQL table:LOAD DATA LOCAL INFILE 'C:/documents/agenda.txt' IGNORE INTO TABLE agenda…
The following piece of code shows how you can load data from a comma separated values file directly into a MySQL table:LOAD DATA LOCAL INFILE 'C:/documents/agenda.txt' IGNORE INTO TABLE agenda…