difference between sql and mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
qumar
Forum Commoner
Posts: 29
Joined: Wed Nov 01, 2006 8:20 am

difference between sql and mysql

Post by qumar »

hi friends,
i want some points on difference between sql and mysql.give some idea.
thanks,
qumar.
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

Post 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.
User avatar
CoderGoblin
DevNet Resident
Posts: 1425
Joined: Tue Mar 16, 2004 10:03 am
Location: Aachen, Germany

Post 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 :wink: One of the most well known commercial databases is ORACLE.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

It's interesting how this thread has nothing to do with PHP....


Moved to Databases.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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.
Post Reply