problem import data

[Gert V]

Hello

I also made a topic in the Newbie section, but until now nobody has give me the right solution.

I want to import data from a file (txt, csv, ...) into a mysql database. The table has several columns and one of them is a column of the datatype enum.

...

mysql> load data infile 'D:\\PRODUCT\\product2.csv'
-> into table PRODUCT
-> fields terminated by ';'
-> optionally enclosed by '"';
ERROR 1265 (01000): Data truncated for column 'Type' at row 1

example of csv-file:
000001;omschrijving1;19;7;7;"4"
000002;omschrijving2;19;8;7;"4"
000003;omschrijving3;19;9;21;"2"
000004;omschrijving4;19;9;7;"4"
000005;omschrijving5;19;7;9;"4"
000006;omschrijving6;19;7;11;"1"

Does somebody know a way to import a delimited file in a table with an enum-column?

Can someone give me an example of a working example?
Is it posssible to display an example of the flat file and the describe of the table and the executed command


Thx

Gert