Answer the question
In order to leave comments, you need to log in
How to execute Load data skipping the id column?
Help with sql query please. They use mysql, I want to unload information from a txt file via LOAD DATA into one column without filling in the previous id, I write this:
LOAD DATA INFILE '/home/user/1.txt' INTO TABLE table;
SET id = NULL
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question