List:General Discussion« Previous MessageNext Message »
From:SGreen Date:September 16 2005 2:32pm
Subject:Re: Differences Between ORACLE SQL PLus and MYSQL SQL
View as plain text  
Phong Nguyen <pnguyen5us@stripped> wrote on 09/15/2005 10:56:57 AM:

> All,
> 
> Could you please tell us what are the differences
> between ORACLE SQL plus and MYSQL SQL? We developed
> application using ColdFusion with Oracle. Now I like
> to point my application to mysql database. How do I
> fix my application to work with Mysql?
> 
> Thankyou
> 

You asked basically two questions:

a) what are the differences between ORACLE SQL plus and MYSQL?

First, I must refer you to the official MySQL documentation. Everything 
you will need to know to answer your question will be in there. I am 
assuming that you already understand Oracle SQL Plus, as you are using it.

http://dev.mysql.com/doc/mysql/en/index.html

It does not do a point-by-point comparison between the two products you 
list but if you understand Oracle and read this to see how you form the 
MySQL equivalent to each Oracle statement you use (you can skip around to 
read just the parts you need then come back and get the rest later), the 
differences will be readily apparent. If you do not already understand 
your Oracle back-end, you have a serious disadvantage to making this a 
smooth transition.

b) How do I fix my application to work with Mysql?

The simple answer is: Change your website's code to use a compatible MySQL 
client library and modify all SQL statements to be MySQL compatible. 

Exactly how you do that with the environment you specified, I don't have a 
clue. I looked at Cold Fusion once (several years ago) so how that tool 
helps to automate the development of the data storage and retrieval 
process is beyond me. How much you need to change your SQL statements 
depends on how they are with MySQL already. One well-known point on how 
MySQL and Oracle differ is in how to define a JOIN in a SQL statement. 
MySQL works best if you use the explicit "[INNER|LEFT|RIGHT] JOIN ... ON 
..." format. AFAIK, Oracle does not support this syntax.

I wish you well. If you have any specific translation issues that you 
cannot resolve by reading the manual, please bring it back to the list. I 
am sure someone will be able to help.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Thread
Differences Between ORACLE SQL PLus and MYSQL SQLPhong Nguyen16 Sep
  • Re: Differences Between ORACLE SQL PLus and MYSQL SQLMartijn Tonies16 Sep
  • Re: Differences Between ORACLE SQL PLus and MYSQL SQLSGreen16 Sep
    • Re: Differences Between ORACLE SQL PLus and MYSQL SQLJosh Trutwin16 Sep