Re: RE: Having Problem With Load Files and AutoNumber id fields

The empty field did not work but the 0 worked beautifully! Thanks everyone! :-) On 11/27/06, Jerry Schwartz <[EMAIL PROTECTED]> wrote: Perhaps that empty field is being interpreted as a string? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 8

RE: Having Problem With Load Files and AutoNumber id fields

Perhaps that empty field is being interpreted as a string? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: John Kopanas [mailto:[EMAIL PROTECTED] > Sent: Friday, November 24,

Re: Having Problem With Load Files and AutoNumber id fields

John Kopanas wrote: Argh... I am autogenerating a load file after parsing and massaging a text file I get from an AS/400 system. My first field is an id that is on auto_number so I put a tab at the begging of the line for each one of my records... it throws a warning for each line... if instead

Re: Having Problem With Load Files and AutoNumber id fields

Hi, My opinion is alter your table so that auto increment column should be the last column. Try importing values for n-1 columns, where the nth column will get increment with auto_increment & get escaped from NULL values. For instance: mysql>create table x (item varchar(10),price int,id int not