不同类型的 SQL 之间的区别？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1326318/
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
Difference between different types of SQL?
提问by RCIX
What are the differences between all of the different types of SQL? I hear of PostgreSQL, SQLite, MySQL, SQL, .... What are the differences between them?
所有不同类型的 SQL 之间有什么区别？我听说过 PostgreSQL, SQLite, MySQL, SQL, .... 它们之间有什么区别？
采纳答案by rahul
SQLis Structured Query Language is a database computer language designed for managing data in relational database management systems (RDBMS).
PostgreSQLis an object-relational database management system (ORDBMS).1It is released under a BSD-style license and is thus free software. As with many other open-source programs, PostgreSQL is not controlled by any single company, but has a global community of developers and companies to develop it.
SQLiteis an ACID-compliant embedded relational database management system contained in a relatively small (~225 KB1) C programming library. The source code for SQLite is in the public domain.
MySQL(pronounced /ma???skju???l/1My S-Q-L, or "My sequel" /ma??si?kw?l/) is a relational database management system (RDBMS)2which has more than 6 million installations. 3MySQL stands for "My Structured Query Language". The program runs as a server providing multi-user access to a number of databases.
SQL是结构化查询语言，是一种数据库计算机语言，旨在管理关系数据库管理系统 (RDBMS) 中的数据。
PostgreSQL是一个对象关系型数据库管理系统 (ORDBMS)。1它是在 BSD 风格的许可下发布的，因此是免费软件。与许多其他开源程序一样，PostgreSQL 不受任何一家公司的控制，而是拥有一个由开发人员和公司组成的全球社区来开发它。
SQLite是一个符合 ACID 的嵌入式关系数据库管理系统，包含在一个相对较小 (~225 KB1) 的 C 编程库中。SQLite 的源代码在公共领域。
MySQL（读作 /ma???skju???l/1My SQL，或“My sequel” /ma??si?kw?l/）是一个关系数据库管理系统 (RDBMS)2，它拥有超过 600 万个装置。3MySQL 代表“我的结构化查询语言”。该程序作为服务器运行，提供对多个数据库的多用户访问。
回答by Prashant Cholachagudda
PostgreSQL, SQLite, MySQL, MS SQL are just database management systemsfrom different vendors
PostgreSQL、SQLite、MySQL、MS SQL 只是来自不同供应商的数据库管理系统
回答by Nifle
回答by Ian Kemp
PostgreSQL, SQLite, MySQL, MSSQL, Sybase = relational database management systems (RDBMSes).
PostgreSQL、SQLite、MySQL、MSSQL、Sybase = 关系数据库管理系统 (RDBMSes)。
SQL, TSQL = the actual languages used by the aforementioned database systems. Although (in theory) SQL is standardised, in practice each vendor has their own "extensions" (variations) on the language - which means that SQL written for MySQL may not work under Sybase, for example.
SQL、TSQL = 上述数据库系统使用的实际语言。尽管（理论上）SQL 是标准化的，但实际上每个供应商在语言上都有自己的“扩展”（变体）——例如，这意味着为 MySQL 编写的 SQL 可能无法在 Sybase 下运行。
回答by bastianneu
Different Vendors= Different Ideas and Concepts. Like every other Programming Problem...every developer solutes it differently and thats great. :-) Learing about this little differences or sometimes big "Messed up" is good.
不同的供应商=不同的想法和概念。就像其他所有编程问题一样……每个开发人员都以不同的方式解决它，这很好。:-) 了解这个小差异或有时大的“搞砸”是好的。
