Doesn't that (the trailing comma) depend upon whether or not you want the default value for the (missing) field, as opposed to "" or 0 used for empty fields?
Either way, you are right - you should be able to import the data. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -----Original Message----- > From: Jason Pruim [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 09, 2007 11:29 AM > To: Jerry Schwartz > Cc: mysql@lists.mysql.com > Subject: Re: Import file into MySQL Database.. > > The Extra commas at the end of some of the lines need to be there to > keep everything in the right order, they represent empty fields... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
