What are the key difference between MySQL and MS SQL Language? [duplicate]

This question already has answers here: Closed 11 years ago.

Possible Duplicate:

Differences Between MySql and MS SQL

What is the key difference between MySQL and SQL Server from the SQL language perspective. The reason why I am asking is that I need to quickly master some basic SQL knowledge and need to find a book to start with.

I find this one through amazon.com Learning SQL, 2nd Edition, however, this book is for MySQL. All other books for MS SQL are big one that cannot be finished in a short time.

So, it is fine I just grab a MySQL book and later I can easily transfer to MS SQL world or I should immediatel开发者_如何学Goy go into MS SQL Server?

// update the title based on the comments ///

---

The following links might help you out.

Note that the two are very different.
If you want to make your live easy, use PostgreSQL, the gap between that and SQL-server is much smaller.

Difference between MySQL and MSSQL

From microsoft and mysql respectively:
http://technet.microsoft.com/en-us/library/cc966396.aspx
http://www.mysql.com/why-mysql/white-papers/mysql_wp_mssql2mysql.php (login required sorry)

On stackoverflow: Differences between MySQL and SQL Server

Difference between PostgreSQL and MySQL

http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL

Difference between postgreSQL and MSSQL

On SO: https://stackoverflow.com/questions/907908/postgres-to-sql-server
and: https://stackoverflow.com/questions/4630891/tips-for-sql-server-developer-picking-up-postgresql

Diff between all three :-)
http://www.postgresonline.com/journal/archives/51-Cross-Compare-of-SQL-Server,-MySQL,-and-PostgreSQL.html
or http://troels.arvin.dk/db/rdbms/

---

This might be a good tutorial to start with SQL - http://philip.greenspun.com/sql/ (rather old, but valid) - though it points more to Oracle, but MySQL is mentioned there.