Re: porting data from oracle to mysql

[manish singh]

ok so now iam doing this

insert into mysql.table1 values (23232, '2004-12-12', 232);
and it works, isee the date in the mysql table.

but now another problem

if there is no data in the date field for a record i get an error

you have an error in the sql syntax near '1111,'',1221)'
query
insert into mysql.table1 values (1111,'',1221);