Page 1 of 1
difference between sql and mysql
Posted: Thu Nov 29, 2007 7:14 am
by qumar
hi friends,
i want some points on difference between sql and mysql.give some idea.
thanks,
qumar.
Posted: Thu Nov 29, 2007 7:31 am
by shiznatix
SQL is a language for interacting with databases. It has become the standard and its kick-butt. You can use it for all databases (at least most of it). Each database will have different quirks but SQL is pretty much always going to work on any database.
MySQL is a database. Just like Postgres is a database. Its not a language, but the actual thing that you use the langauge (SQL) to talk to.
Posted: Thu Nov 29, 2007 8:56 am
by CoderGoblin
I will point out however that although SQL is the baseline all common databases use, each may have it's own oddities and branches away from the core SQL definition. Things like how to get a list of information paginated by LIMIT and OFFSET may differ for example. Things like the basic SQL commands INSERT and SELECT are always the same.
Once you know the fundamentals of SQL you can apply it to any database. If something doesn't work you may need to check the documentation to figure if the syntax is slightly different.
Here is a list of
Databases. The most common ones you find people using on these forums are MySQL (the most common) and PostgreSQL (postgres). These are free

One of the most well known commercial databases is ORACLE.
Posted: Thu Nov 29, 2007 10:12 am
by feyd
It's interesting how this thread has nothing to do with PHP....
Moved to Databases.
Posted: Thu Nov 29, 2007 10:15 am
by RobertGonzalez
SQL vs MySQL == Apples vs. Oranges.
SQL = Structured Query Language - A language for communicating with databases to insert, update, remove and retrieve data.
MySQL = The world's most popular open source database.