On Friday 20 August 2004 15:58, Boyd E. Hemphill might have typed: > The quick answer is to save your data as a comma delimited file with no > headers. (I suggest actually using bang | since your data may contain > commas.)
A properly comma delimited file will not have problems with commas in the fields, because the fields will be quoted and escaped (and the load infile parser supports all of this too). Text::CSV_XS for perl is a good validator :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]