|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
From: Jerry Schwartz (jschwartz
the-infoshop.com)
Date: Thu Aug 09 2007 - 11:00:05 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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:japruim
raoset.com]
> 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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]