List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:August 9 2007 4:00pm
Subject:RE: Import file into MySQL Database..
View as plain text  
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@stripped]
> Sent: Thursday, August 09, 2007 11:29 AM
> To: Jerry Schwartz
> Cc: mysql@stripped
> 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...



Thread
Import file into MySQL Database..Jason Pruim8 Aug
  • RE: Import file into MySQL Database..Stephen Sunderlin8 Aug
    • Re: Import file into MySQL Database..Jason Pruim8 Aug
      • Re: Import file into MySQL Database..Mark Kelly8 Aug
  • Re: Import file into MySQL Database..Gary Josack8 Aug
    • Re: Import file into MySQL Database..Jason Pruim8 Aug
      • Re: Import file into MySQL Database..Gary Josack8 Aug
        • Re: Import file into MySQL Database..Jason Pruim9 Aug
          • RE: Import file into MySQL Database..Edward Kay9 Aug
            • Re: Import file into MySQL Database..Jason Pruim9 Aug
              • RE: Import file into MySQL Database..Jerry Schwartz9 Aug
                • Re: Import file into MySQL Database..Jason Pruim9 Aug
                  • RE: Import file into MySQL Database..Jerry Schwartz9 Aug
  • Re: Import file into MySQL Database..Christian High8 Aug