Results 1 to 3 of 3
Sep 17, 2012, 15:23 #1
- Join Date
- Oct 2011
- 0 Post(s)
- 0 Thread(s)
LOAD DATA INFILE IGNORE LAST LINE ???
I have a csv file which I am using to populate my table ... the file looks like this
This is the data, I will ignore this line when inserting
john, smith, 25
mike, jones, 19
kelly, smith, 22
This line I don't want to add
I use the following to load my data ...
All works good, but is there any way to IGNORE the LAST LINE 'This line I don't want to add' ????