MySQL equivalent of SQL Bulk Insert using formatfile

[Phizzle]

I need help using MySQL to do bulk inserts in a way similar to the was SQL uses a Format file. The txt file I'm importing from has a lot of information in a single row w/ fixed column widths separated by commas. Can anyone assist me w/ the proper syntax in MySQL to define the columns using either INSERT or LOAD DATA?

Thank you!
Phizzle

 

[r937]

LOAD DATA INFILE is what you need

what kind of help did you want with it?

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon