How to Ignore first column in MySQL query saving txt to database?

Question

I have txt file
text1|text2|text3|text4,
text1|text2|text3|text4,
text1|text2|text3|text4,
text1|text2|text3|text4,
text1|text2|text3|text4,

 ("LOAD DATA  INFILE '1.txt' INTO TABLE `main`
                    FIELDS TERMINATED BY '|'
                    LINES TERMINATED BY ','
                    ");

main table view is id value1 value2 value3 value4

everything works ok

i need to ignore first column (id) !!

How to change mysql query to insert

text1 to value1
text2 to value2
text3 to value3

etc..

score 0 · Accepted Answer · answered Aug 13 '15 at 18:36

0

Use IGNORE, like this:

LOAD DATA INFILE '/tmp/test.txt' INTO TABLE test IGNORE 1 LINES;

answered Aug 13 '15 at 18:36

Jim Archer

1,109
2
22
40

He doesn't want to skip the first line he wants to skip the id column on each line. – Richard - Rogue Wave Limited Aug 13 '15 at 19:27
Oh you're right but its already answered. – Jim Archer Aug 13 '15 at 21:33

How to Ignore first column in MySQL query saving txt to database?

1 Answers1