Differences between MySQL and MS SQL / Oracle PL/SQL

[bsulliva]

Long time reader...first time poster....

I have the chance to pick up some side work on a small MySQL assignment at night and over some weekends.. I would love the chance to add MYSQL to my toolbox, but until this point I have never used the product. I have 10 year experience with SQl and PL/SQL, are there many differences between the different platforms, or should I be OK with just floating over to MYSQL and "Going for it!".

 

[sleipnir214]

The difference between MySQL and MSSQL or Oracle is, basically, complexity.

MySQL is designed to be a lightweight, robust database server, so it does not support some features you're used to:[ul][li]stored procedures or functions[/li][li]views[/li][li]subqueries[/li][/ul]






Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[BNPMike]

If you're used to Oracle, you should find MySQL a doddle. Having said that, I'm sure as a seasoned professional, the first thing you'll do is buy the Manual.

Are there differences? I'm surprised how different SQL platforms have become. In the (good) old days, people just pulled some rows out, fiddled with them and put them back. Now people want to use 50 line SQL statements with all sorts of functions. That's when things get portability problems.