MySQL Forums
Forum List  »  Oracle

Re: difference in SQL syntax
Posted by: Josh Chamas
Date: November 16, 2004 06:33PM

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.



Josh Chamas
Director, Professional Services
MySQL Inc.,
Get More with MySQL!

Options: ReplyQuote

Written By
November 08, 2004 03:26AM
Re: difference in SQL syntax
November 16, 2004 06:33PM
August 23, 2006 01:40AM
October 15, 2006 11:09PM
October 26, 2006 05:33AM
November 06, 2006 11:45PM
October 31, 2007 10:27PM
September 28, 2007 07:17AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.