Warnings after LOAD DATA statement

2002-03-24 Thread Maribel Piloto
Hi all, I'm new to the list and new to MySQL. I've been working on creating my first db and I've encountered a problem I'm hoping someone here can help me with. I have a text file with the following three lines: V-AIG001|AIGLON'S MUSIC VIDEOS|http://www.aiglon.prv.pl/|\N| V-AIG002|AIGLON'S

RE: Warnings after LOAD DATA statement

2002-03-24 Thread Nick Arnett
-Original Message- From: Maribel Piloto [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 24, 2002 10:24 AM [snip] The data is loading fine and the NULL values are in fact correctly entered as NULLs but I'm getting this warning after the LOAD statement: Records: 3 Deleted: 0

Re: Warnings after LOAD DATA statement

2002-03-24 Thread Paul DuBois
At 13:23 -0500 3/24/02, Maribel Piloto wrote: Hi all, I'm new to the list and new to MySQL. I've been working on creating my first db and I've encountered a problem I'm hoping someone here can help me with. I have a text file with the following three lines: V-AIG001|AIGLON'S MUSIC

RE: Warnings after LOAD DATA statement

2002-03-24 Thread Paul DuBois
At 10:50 -0800 3/24/02, Nick Arnett wrote: -Original Message- From: Maribel Piloto [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 24, 2002 10:24 AM [snip] The data is loading fine and the NULL values are in fact correctly entered as NULLs but I'm getting this warning after