manish singh wrote:
> iam currently working on integrating a mysql
> server with the currently
> existing group of oracle dbs
This is great to hear! Many people think that mixing databases is not good,
but there are certainly places where deploying mixed environments from
various vendors fulfills your organization's requirements optimally ...
> my first question
> 1) is there any difference in the sql syntax of
> oracle and mysql
Yes, but if you stay with ANSI SQL standard, then there will be
less headaches for you to deal with. The most common differences
is in dealing with SEQUENCES and DATE types differently. In Oracle
it is common to say 'sysdate + 1' to mean 1 day from now, but MySQL
support the ANSI SQL method of 'CURRENT_DATE + interval 1 day',
or MySQL specific 'now() + interval 1 day'
Also note that MySQL 4.1 supports extensive subqueries, and this
has been released production ready recently with 4.1.7
If you need views, triggers, and stored procedures, then you will
need MySQL 5.x, but this will not be production ready for another
4-5 months. You can however download the 5.0.1 alpha and
experiment with it today as it has stored procedures and views
implemented today.
> if yes then
> 2) are there any resources on the net which would
> explain the difference between
> the two syntactically and from the data type point
> of view so that i can modify the
> current queries to run on mysql.
We have a document internally that we provide to clients that details
things like differences in function calls, data types, etc. I will be working
on getting this published as a more general white paper that we can
circulate publically, but have nothing more for you at this time.
Regards,
Josh
Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL!
http://www.mysql.com/consulting