Re: Append with LOAD DATA INFILE

[Guelphdad Lake]

even better Dan, if you specify the columns in the infile you can put them in the order you need.

if your table is

primarykeycolumn, a, b, c, d, e

and your data in your file is only a, b, e

then use:

LOAD DATA INFILE
  yourfilehere
INTO TABLE
  tablename
FIELDS TERMINATED BY
  xxxx
LINES TERMINATED BY
  xxxx
(a, b, e)

for example