LOAD DATA INFILE Syntax

[angel rivero]

Hi all, I need import this txt file in DB MySQL with LOAD DATA INFILE Syntax:

;;110; 01/01/2014 01:30:00; OPAC; ALRAF; 3INCRE; ;

And tried:

LOAD DATA INFILE 'D:\\example.txt' IGNORE INTO TABLE `tbl_x` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n'

But the import in the table is wrong because the first two ";;" move forward all data, can you help me?
Thanks in advance.



Edited 3 time(s). Last edit at 04/10/2014 08:43AM by angel rivero.