sql vs mysql help?

Question

Hi i am using SQL queries using oracle platform. Will using this querie better prepare for using mysql. Also is there any chance this language will be obsolete in 5 years time just like some languages before. Also what is the point of me learning sql if it is going to be obsolete and i am going to have to learn a new one

Answer 1

SQL has been the standard database query language for a while, I don't see it becoming obsolete any time soon. All databases use different forms of SQL for querying, but they are similar, so if you learn SQL for Oracle it should be fairly easy to learn SQL for MySQL.

Answer 2

Structured Query Language (SQL) will be around for years to come, I wouldn't worry about it disappearing any time soon if I were you. MySQL is an open-source database engine which implements the SQL standard. While there are some differences from implementation to implementation of the SQL standard, they are more or less the same; that said, if your goal is to become familiar with the peculiarities of the MySQL implementation, then you should probably use MySQL. Since MySQL is free -- whereas Oracle is not -- you will probably find it more advantageous to use MySQL, unless you have a compelling reason to choose the Oracle implementation.

Answer 3

The company I work for is a Fortune 500 company.

We have many applications built on SQL servers and I can't imagine that SQL will be obsolete anytime soon. We are just beginning to implement Oracle business suite applications as well. I can't see our organization investing in products that will be obsolete in 5 years. Of course anything is possible when it comes to software platforms. Any experience with SQL formats will be helpful with MYSQL, but I'm not sure why you are interested in using MYSQL, since it is a limited SQL server for development purposes. I believe that MYSQL has already been replaced with a newer version.

Answer 4

I agree with ColinC. I've used MS SQL Server, Oracle, and MySQL, and I've found MySQL to be very comparable in terms of performace to the others. 50 queries / minute is no big deal, although more RAM would definitely help. I run an application that uses MySQL which does several hundred queries per minute during peak times. If your queries are taking a long time to execute, you may want to look into optimizing the queries, or tuning the database.

Answer 5

SQL is safe for a good while to come.



If you can stick to ANSI Standard SQL this is transportable to almost any sql based database. Oracle has lots of proprietary extension to the ANSI standard as do all the other database engines. As long as you are aware that you are using a proprietry extension and dont try to use the same thing on a different sql engine you will be fine.



You just have to re-learn the new ways of doing the proprietary bit when you move between database's.

Answer 6

No, MySQL will NOT be out moded in five years. It may go under after 15 years, but after 25 years, you'll still find SQL code. Afterall, that EVIL crappy language called COBOL just refuses to die, and SQL was created to replace it!



You can check out the 'MySQL' reference manual at



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