On Jun 5, 2004, at 11:40 PM, David Blomstrom wrote:
Here are a few rows from the comma delimited file I imported. Do you have a hunch what might be going on here?
Thanks.
"gd","oat",239,,"Grenada","nat" "gp","oat",240,,"Guadeloupe","dep" "ht","oat",241,,"Haiti","nat" "is","oat",242,,"Iceland","nat" "jm","oat",243,,"Jamaica","nat"
Do you see where you have two commas together such as
239,,"Grenada"
If the field that lines up with the field between ,, does not allow NULL, then an error will occur. Either redefine the field to allow NULL, or use regex on that file to convert ,, to ,"", or ,0, as appropriate.
-- greg willits
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
