MySQL Forums :: Newbie :: importing Text to MySQL


Advanced Search

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!)

Cheers,

Options: ReplyQuote


Subject Written By Posted
importing Text to MySQL Lee Parkies 09/10/2009 05:32AM
Re: importing Text to MySQL Tom Melly 09/10/2009 05:37AM
Re: importing Text to MySQL Rick James 09/10/2009 08:56AM
Re: importing Text to MySQL Jay Alverson 09/10/2009 09:05AM
Re: importing Text to MySQL Tom Melly 09/10/2009 12:14PM
Re: importing Text to MySQL Lee Parkies 09/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.