hi friends,
i want some points on difference between sql and mysql.give some idea.
thanks,
qumar.
difference between sql and mysql
Moderator: General Moderators
- shiznatix
- DevNet Master
- Posts: 2745
- Joined: Tue Dec 28, 2004 5:57 pm
- Location: Tallinn, Estonia
- Contact:
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.
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.
- CoderGoblin
- DevNet Resident
- Posts: 1425
- Joined: Tue Mar 16, 2004 10:03 am
- Location: Aachen, Germany
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.
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
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA