Loading data into MySQL from txt

A

admin

Administrator
Staff member
What would be the best MySQL syntax to load data from a .txt file, with fields delimited by a space and lines delimited by a new line? For example:

01-02-2001 17:13:58 01:00000372E86D
01-02-2001 17:15:09 01:000003727BDC

Also, is it possible to have a column that auto increments a number as a primary key, while also using LOAD DATA to populate the table?

Thanks,

Jason
 
You must log in or register to reply here.
Back
Top