MySQL Forums
Forum List  »  Newbie

importing Text to MySQL
Posted by: Lee Parkies
Date: September 10, 2009 05:32AM

hey guys,

i have just started with MySQL, and thought loading simple data my SQL would be easy but it continues to fail i have tried every method of text layout. I using:

/mysql> LOAD DATA LOCAL INFILE 'test.txt' INTO TABLE business;

I have an ID (primary) field and 3 other varchar(40) fields

I have tried importing the text with spaces, tabs, commas.. but cannot get more then 1 line.

Any ideas? (i have looked all over the net for a solution!)


Options: ReplyQuote

Written By
importing Text to MySQL
September 10, 2009 05:32AM
September 10, 2009 05:37AM
September 10, 2009 08:56AM
September 10, 2009 09:05AM
September 10, 2009 12:14PM
September 13, 2009 06:54PM

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.