MySQL and SQL

nicdp

Untill now I always used PHP with MySQL.

What are the differences wirking with MySQL and SQL?

Is it easy or difficult to use SQL to build web-based applications after having uses MySQL?

funkdrm

hmm..maybe I'm missing your question. SQL stands for Structure Query Language. If your using MySQL then you must already be using SQL the language. Correct me if I'm wrong but I don't believe there is a DATABASE called "SQL." SQL is what you use to interact with a database.

polson

SQL is a language that MySQL uses. Read about SQL standards here :

http://epoch.cs.berkeley.edu:8000/sequoia/dba/montage/FAQ/SQL_TOC.html
http://www.jcc.com/SQLPages/jccs_sql.htm

Read about MySQL here :
http://mysql.com/information/

And through all that it should make sense :-) Fact is, MySQL does not support all of SQL, has some of its own functions, etc. But it supports most of it. Think of SQL as a language, MySQL communicates with and through it but doesn't have the entire vocabulary and has added a few words itself. The degree of this deviation depends on each database has its differences, this is why so many SQL databases exist. Check out :

http://www.codehound.com/SQL/

It really is nice to find such differences.

Anon

I think he might be talking about Microsoft's SQL Server. It's often described simply as "SQL".

Luke

nicdp

That's it! Please tell me more!

Anon

Well, I'm slightly reticient to say, only because I've just begun working with MySQL, so a comparison might prove faulty, but I am an expert with SQL Server. I would check out http://www.microsoft.com/sql to find specific areas to compare or constrast between the two.

-Luke