0
0
0leg5ergeev2017-05-10 19:13:24
MySQL
0leg5ergeev, 2017-05-10 19:13:24

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;

and of course, swears at text import into id. Google advice did not help or I misunderstood them 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 question

Ask a Question

731 491 924 answers to any question