List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 24 2002 8:39pm
Subject:Re: Warnings after LOAD DATA statement
View as plain text  
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
Thread
Warnings after LOAD DATA statementMaribel Piloto24 Mar
  • RE: Warnings after LOAD DATA statementNick Arnett24 Mar
    • RE: Warnings after LOAD DATA statementPaul DuBois24 Mar
  • Re: Warnings after LOAD DATA statementPaul DuBois24 Mar