1 | initial version |
To specify which columns to load when using LOAD DATA INFILE in MySQL, you can use the following syntax:
LOAD DATA INFILE 'file.txt'
INTO TABLE mytable
(column1, column2, column3)
In this example, the columns specified (column1, column2, column3) will be loaded from the file 'file.txt' into the MySQL table 'mytable'. If the file contains additional columns, they will not be loaded.
Note that the order of the columns in the file must match the order specified in the command. If you leave out a column or specify it incorrectly, you may get an error or unexpected results.