MySQL LOAD DATA LOCAL INFILE tab delimited text file syntax

Question

I'm using the MySQL LOAD DATA LOCAL INFILE command to load a tab delimited text file. But when I include the column list I get an error code 1064.

LOAD DATA LOCAL INFILE '/myfile.txt'
        INTO TABLE mytable 
        (column1, column2, column3)
        FIELDS TERMINATED by '\t'
        LINES TERMINATED BY '\n'
        IGNORE 10 LINES;

The non-column version works:

 LOAD DATA LOCAL INFILE '/myfile.txt'
        INTO TABLE mytable 
        FIELDS TERMINATED by '\t'
        LINES TERMINATED BY '\n'
        IGNORE 10 LINES;

What is causing the syntax error?

haz · Accepted Answer · 2017-04-09 11:09:31Z

2

The error is being caused by the position of the column list, which should be in the last row, i.e.:

LOAD DATA LOCAL INFILE '/myfile.txt'
    INTO TABLE mytable 
    FIELDS TERMINATED by '\t'
    LINES TERMINATED BY '\n'
    IGNORE 10 LINES
    (column1, column2, column3);

answered Apr 9, 2017 at 11:09

haz

8002 gold badges12 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL LOAD DATA LOCAL INFILE tab delimited text file syntax

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related