MySQL Forums
Forum List  »  Knowledge Base

load data local infile
Posted by: bing li
Date: November 09, 2009 08:47AM

Hallo everyone.
I want to add the pet.txt into my MySql table. But it failed.Could someone explain why? Thank you.

pet.txt
snoppy thomas spec2 m 2008-01-02 NULL


load data local infile'C:/Users/bing/Documents/book/mysql_5_1/pet.txt'

All the columns screez into one column, which I dont want.

Options: ReplyQuote


Subject
Views
Written By
Posted
load data local infile
3966
November 09, 2009 08:47AM
1726
November 20, 2009 06:26AM


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.