Command Mysql MySQL

  1. Home
  2. MySQL
  3. Command Mysql
  4. 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);