LOAD DATA..........

I have a textfile (tmp.csv) with the following contents:
"01-01-12";"text1";"text2"
"08-01-12";"text1, more text, more text";"text2"

i wanted to import this into a temporary table, so i did:
CREATE TABLE tmp (i1 varchar(100), i2 varchar(100), i3 varchar(100));

and to import this file:
LOAD DATA INFILE 'tmp.csv' INTO TABLE tmp FIELDS TERMINATED BY ';'
OPTIONALLY ENCLOSED BY '"';

it gives warnings like:
Row 1 was truncated; it contained more data than there were input columns

When i do a select * from tmp, i get:
"01-01-12 | text1 | text2"
"08-01-12 | text1, more text, more text | text2"

What should i do to import such simple text file ?


--
Luuk

On 29-12-2011 11:42, Luuk wrote:
> I have a textfile (tmp.csv) with the following contents:
> "01-01-12";"text1";"text2"
> "08-01-12";"text1, more text, more text";"text2"
>
> i wanted to import this into a temporary table, so i did:
> CREATE TABLE tmp (i1 varchar(100), i2 varchar(100), i3 varchar(100));
>
> and to import this file:
> LOAD DATA INFILE 'tmp.csv' INTO TABLE tmp FIELDS TERMINATED BY ';'
> OPTIONALLY ENCLOSED BY '"';
>
> it gives warnings like:
> Row 1 was truncated; it contained more data than there were input columns
>
> When i do a select * from tmp, i get:
> "01-01-12 | text1 | text2"
> "08-01-12 | text1, more text, more text | text2"
>
> What should i do to import such simple text file ?
>
>

adding a ';' at the end of the line seemes to solve the problem

--
Luuk