The difference between MySQL and SQL

[Ahmed Ashraf]

Hello w3schools community !

I would like to know ..

- What is exactly the difference between SQL ( Structured query language ) and MySQL ?, ( with examples if possible )

- Does learning SQL suffice ? Or should I use a RDBMS such as MySQL, Oracle .. etc ?

Thank you .

Edited November 3, 2018 by Ahmed Ashraf

[dsonesuk]

SQL stands for Structured Query Language, that is used for accessing database to manipulate data stored in those databases.

MYSQL is a open source database management system, mostly used in a Linux server environment that uses SQL.

MSSQL (MicroSoft - SQL) is a NON open source database management system, by Microsoft (and therefore expensive) and mostly used in Microsoft server environment that uses SQL.

[ishan_shah]

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, Oracle, Informix, Postgres, etc. MySQL is an RDMS (Relational Database Management System).

When considering a utility for data management the two most popular choices are MySQL and SQL Server. Both are efficient at keeping your data organized and readily available through a user interface. Both technologies have the concept of the schema (that is table storage) for data storage.