Mega Code Archive

 

Categories / MySQL / Command Mysql

 

LOAD DATA assumes the columns in the datafile have the same order as the columns in the table

mysql> LOAD DATA LOCAL INFILE 'mytbl.txt' INTO TABLE mytbl (b, c, a);