loading text into table fields -help

[leegold]

Ok I got a question:
Let's say a tab delimited file like this:

name is varchar (60)
bio is TEXT data type

name<tab>bio
Jack<tab>name: My name is Jack\ncar: I have a chevy car\npet: My pet's named Fido\n
Jane<tab>name: My name's Jane\ncar: I have a VW car\npet: I don't have a pet\n
....

How do I LOAD that into MYSQL ?
I want name field and the a text bio field but how do I get it in a table assuming I have line breaks...I'm willing to globally edit the file if needed....

Thanks

 

[KarveR]

I would suggest checking the online docs for LOAD DATA INFILE or LOAD DATA LOCAL INFILE.

The docs are here

Mainly it depends on your system and access rights.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.