>Thanks for the reply. I was a little confussed on the exact defintion of >a "line", I thought it meant a whole row of data. >The space seperated fields worked great, but still gave me the error: >"ERROR 1054: Unknown column 'col1' in 'field list' >I could not find anywhere on how to define the "field list".
In my example, col1 was just a place holder for the first column you wish to load data into. This info will come from the mysql command DESC persondata; This will give you a list of the columns which you can then use to specify which data element from the line you want to go into each column from the table. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]