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 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: John Kopanas [mailto:[EMAIL PROTECTED] > Sent: Friday, November 24, 2006 11:13 AM > To: mysql@lists.mysql.com > Subject: Having Problem With Load Files and AutoNumber id fields > > 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 > of putting an autonumber I put a random number it works perfectly. > How can I get it to work? > > Sample line in my load file that works: > 111111111111111111111 3066001210010000001467 SMART ALARMS > INC 201 > MILLWAY AVE UNIT #8 \N \N VAUGHAN ON L4K 5K8 > 0 1999-9-1 > 00:00:00 1999-9-1 00:00:00 > > Sample line that does not work: > 3066001210010000001467 SMART ALARMS INC 201 > MILLWAY AVE UNIT > #8 \N \N VAUGHAN ON L4K 5K8 0 > 1999-9-1 00:00:00 1999-9-1 00:00:00 > > My code that generates the sample line that does not work: > tempfile.puts > "\t#{record[0,22].strip}\t#{record[22,32].strip}\t#{record[54, > 32].strip}\t#{record[86,32].strip}\t#{record[118,32].strip}\t# > {record[150,30].strip}\t#{record[180,2].strip}\t#{record[182,7 > ].strip}\t0\t2000-01-01 > 00:00:00\t2000-01-01 00:00:00" > > How can I get mysql to put the auto_numbers in for me? Why is it even > accepting my numbers? > > Thanks :-) > > Does anyone also know how I can see the warnings created by loadfile? > All I just see is the summary with skipped and warnings. > > Thanks :-) > -- > John Kopanas > [EMAIL PROTECTED] > > http://www.kopanas.com > http://www.cusec.net > http://www.soen.info > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >
-- John Kopanas [EMAIL PROTECTED] http://www.kopanas.com http://www.cusec.net http://www.soen.info -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
