OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
RE: Import file into MySQL Database..

From: Jerry Schwartz (jschwartzthe-infoshop.com)
Date: Thu Aug 09 2007 - 11:00:05 CDT


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:japruimraoset.com]
> Sent: Thursday, August 09, 2007 11:29 AM
> To: Jerry Schwartz
> Cc: mysqllists.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