Thursday 12 April 2012

Difference between SQL and MySQL

Comparing SQL and MySQL is like comparing Apple and Apple Juice. SQL is a language.  Specifically, the "Structured Query Language" MySQL is one of several database systems, or RDMS (Relational Database Management System).  MySQL is one of several RDMS's, others of which are Oracle, Informix, Postgres, and MSQL. All of these RDMSs use SQL as their language.  Each of them has minor variations in the "dialect" of SQL that they use, but it's all still SQL.

SQL is used to manipulate database or to create a database. It's actually a common language. MySQL is an actual computer application. You must need to download or collect it and install it. MySQL is one of the most popular open source database management system. MySQL has an SQL interpreter.MySQL can be used as the back engine database for several kinds of applications and it's one of the best choice for many web programmers for web-base application.

Basically, the difference between SQL and MySQL is the same as the difference between Spanish and Mexicans.   Spanish is a language.  Mexicans are one of a group of people that use Spanish.  Mexican Spanish and Spaniard Spanish are mildly different in dialects, but they're still Spanish.

No comments:

Post a Comment