MySQL Forums
Forum List  »  Newbie

Re: Append with LOAD DATA INFILE
Posted by: Guelphdad Lake
Date: February 20, 2009 09:40AM

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

Options: ReplyQuote


Subject
Written By
Posted
Re: Append with LOAD DATA INFILE
February 20, 2009 09:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.