I'm trying to load a csv file into MySQL database. I tried using LOAD DATA INFILE but i managed only to load one row of record. While i very much would like all the records from the csv file to be inside my database table. Any idea what is wrong? I am under the impression that LOAD DATA INFILE will save all the record within a csv file into the table is use correctly.
Below is my SQL statement:
load data infile 'E:/030425_203_126_222_222.csv' into table voip_db.April2003 fields terminated by ',' lines terminated by '\n';
The file is not created by me but by a device. All files created are the same. It will defeat the purpose of having this system if i'm going to alter the content of the file.
Is there any other similar syntax that i can use that gives me the same result?
Will be very greatful if you can help me out in this