Wednesday, October 13, 2010

Differences between SQL and MySQL

SQL stands for Structured Query Language.
It's a standard language for accessing and manipulating databases.
MySQL is a database management system, like SQL Server 2005, Oracle, Informix, Postgres etc.
MySQL is a RDMS (Relational Database Management System).
All types of RDMB use 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.

---------------------------------------------------------------------------------------------------------------------------
SQL is a language used with databases, mySQL is a database application that uses SQL.

SQL is a common  database computer language designed for the retrieval and management of data in relational database management systems (RDBMS) -- basically a standard interactive and programming language for querying and modifying data and managing databases.  Very standard for uses ranging from the simplest Microsoft Access applications, up to complex multi-server distributed Oracle applications.

MySQL is a multithreaded, multi-user SQL database management system (DBMS) providing multi-user access to a number of databases.  MySQL is commonly the back engine database for a great many applications, and often the database of choice for web-based applications.

Comparing the two is a little like comparing the English language to Tom Clancey's last book, one uses the other -- but from there the differences are many.

No comments: