MySQL Forums
Forum List  »  Newbie

Re: Text file import
Posted by: pearsojd
Date: August 20, 2004 10:27AM

Hi,

If you want to load selected columns, use the column name arguments for the colums you want to load.

eg. load data infile 'my_file.txt' (adress,name,id)

You need to be carful and list the order of the attributes as the order they appear in the table.

James

Options: ReplyQuote


Subject
Written By
Posted
August 19, 2004 01:10PM
Re: Text file import
August 20, 2004 10:27AM


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.