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.

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

Written By
load data local infile
November 09, 2009 08:47AM
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.