Re: porting data from oracle to mysql

[manish singh]

i tried the LOAD DATA INFILE command and got the following:

first i dumped the oracle table data into a text file
the fields are separated by space and line by new line( output of a simple select *)

now i do this from the mysql prompt

mysql> load data local infile 'd:/manish/spooled_files/test.txt' into
-> table tms_compliance_trend
-> fields terminated by ' '
-> lines terminated by '\r';

and got thie result
Query OK, 3338 rows affected (0.27 sec)
Records: 3338 Deleted: 0 Skipped: 0 Warnings: 3578

now how can i see what these warnings are?