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 VIDEOS|http://www.aiglon.prv.pl/|\N|
>V-AIG002|AIGLON'S MUSIC VIDEOS|http://www.aiglon.prv.pl/|V-WAR001|
>V-AMA001|AMAR'S MUSIC VIDS|http://www.angelfire.com/b/BElanna/xms.html|\N|
>
>I have a table called vsites I'm trying to load this data in. The
>table looks like this:
>
>+-----------+--------------+------+-----+---------+-------+
>| Field | Type | Null | Key | Default | Extra |
>+-----------+--------------+------+-----+---------+-------+
>| vsite_ID | varchar(10) | | PRI | | |
>| vsite1 | varchar(100) | | MUL | | |
>| vurl1 | varchar(150) | | | | |
>| vsite2_ID | varchar(10) | YES | | NULL | |
>+-----------+--------------+------+-----+---------+-------+
>
>I'm using this statement to load the data into the table:
>
>LOAD DATA INFILE "vsites.txt" INTO TABLE vsites FIELDS TERMINATED BY '|';
>
>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 Skipped: 0 Warnings: 3
>
>I don't understand why I'm getting the warnings or what they're about.
Your table contains 4 columns and your data files have 5 columns.
The warnings are problably related to the extra columns, one per each
of your three lines.
If you don't see the extra column, notice that your data lines end
with "|". That means there's an extra empty column at the end of each
line. You can test this theory by deleting the "|" at the end of
the lines and loading the file again.
>
>I would appreciate it if anyone could clue me in as to what I may be
>doing wrong.
>
>MP
