Re: porting data from oracle to mysql

[Josh Chamas]

manish singh wrote:
> 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);

Did you try using NULL instead ?

Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting