MySQL 和 MS SQL 语言之间的主要区别是什么？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6131039/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What are the key difference between MySQL and MS SQL Language?
提问by q0987
Possible Duplicate:
Differences Between MySql and MS SQL
可能的重复：
MySql 和 MS SQL 之间的差异
What is the key difference between MySQLand SQL Serverfrom 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.
之间有什么主要区别MySQL和SQL Server从SQL语言的角度。之所以这么问，是因为我需要快速掌握一些基本的SQL知识，需要找本书入手。
I find this one through amazon.com Learning SQL, 2nd Edition, however, this book is for MySQL. All other books for MS SQLare big one that cannot be finished in a short time.
我通过 amazon.com Learning SQL, 2nd Edition 找到了这本书，但是，这本书适用于MySQL. 所有其他的书MS SQL都是大的，不能在短时间内完成。
So, it is fine I just grab a MySQLbook and later I can easily transfer to MS SQLworld or I should immediately go into MS SQL Server?
所以，我只是拿起一本MySQL书，然后我可以轻松地转移到MS SQL世界，还是我应该立即进入MS SQL Server？
// update the title based on the comments ///
// 根据评论更新标题 ///
采纳答案by Johan
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 thatand SQL-server is much smaller.
请注意，两者非常不同。
如果您想让您的生活更轻松，请使用 PostgreSQL，它与 SQL-server之间的差距要小得多。
Difference between MySQL and MSSQL
MySQL 和 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)
分别来自 microsoft 和 mysql：
http : //technet.microsoft.com/en-us/library/cc966396.aspx
http://www.mysql.com/why-mysql/white-papers/mysql_wp_mssql2mysql.php（需要登录抱歉)
On stackoverflow: Differences between MySQL and SQL Server
在 stackoverflow：MySQL 和 SQL Server 之间的差异
Difference between PostgreSQL and MySQL
PostgreSQL 和 MySQL 的区别
http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL
http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL
Difference between postgreSQL and MSSQL
postgreSQL 和 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
在 SO 上：https: //stackoverflow.com/questions/907908/postgres-to-sql-server
和：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/
三者之间的差异:-)
http://www.postgresonline.com/journal/archives/51-Cross-Compare-of-SQL-Server,-MySQL,-and-PostgreSQL.html
或http://troels.arvin .dk/db/rdbms/
回答by malkia
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.
这可能是从 SQL 开始的一个很好的教程 - http://philip.greenspun.com/sql/（相当旧，但有效） - 虽然它更多地指向 Oracle，但在那里提到了 MySQL。
