Loading table from CSV - Help required

[Subramanian Santhanam]

Hi,

I have a table like this

create table test(emp_no integer primary key,
emp_name varchar(25),
doj date);

I have to load it with the following CSV file

1,"Sam,Daniel",2008-11-01
2,"Jennifer,Jane",2008-05-11
1,"Louie,Philip",2008-04-23
4,"David,Alfred",2008-13-11


I used the following load data query to load my table

load data local infile 'f:\\tools\\uploader wfm\\load.csv' into table
test fields terminated by ',' optionally enclosed by '"'
lines terminated by '\r\n';

The following is the output of the above query

Query OK, 3 rows affected, 1 warning (0.03 sec)
Records: 4 Deleted: 0 Skipped: 1 Warnings: 1

I executed show errors and show warnings command. The results are as follows

mysql> show errors;
Empty set (0.00 sec)

mysql> show warnings;
+---------+------+------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------+
| Warning | 1265 | Data truncated for column 'doj' at row 4 |
+---------+------+------------------------------------------+
1 row in set (0.00 sec)

The issue here is I am not getting any clue about the rejected rows. How to get the info about the rejected rows?

The following is the content of my table after upload.

mysql> select * from test;
+--------+---------------+------------+
| emp_no | emp_name | doj |
+--------+---------------+------------+
| 1 | Sam,Daniel | 2008-11-01 |
| 2 | Jennifer,Jane | 2008-05-11 |
| 4 | David,Alfred | 0000-00-00 |
+--------+---------------+------------+
3 rows in set (0.00 sec)


Thanks & Regards,
Subbu S.