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,....他们之间有什么不同?
6 个解决方案
#1
15
SQL is Structured Query Language is a database computer language designed for managing data in relational database management systems (RDBMS).
SQL是结构化查询语言，是一种用于管理关系数据库管理系统(RDBMS)数据的数据库计算机语言。
PostgreSQL is an object-relational database management system (ORDBMS).1 It 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.
PostgreSQL是一个对象关系数据库管理系统(ORDBMS)。它是在bsd风格的许可下发布的，因此是免费的软件。和许多其他开源项目一样，PostgreSQL不是由任何一家公司控制的，而是有一个由开发者和公司组成的全球社区来开发它。
SQLite is 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.
SQLite是一个兼容acid的嵌入式关系数据库管理系统，包含在一个相对较小的(~225 KB1) C编程库中。SQLite的源代码属于公共领域。
MySQL (pronounced /maɪˌɛskjuːˈɛl/1 My S-Q-L, or "My sequel" /maɪˈsiːkwəl/) is a relational database management system (RDBMS)2 which has more than 6 million installations. 3 MySQL stands for "My Structured Query Language". The program runs as a server providing multi-user access to a number of databases.
MySQL(发音/ maɪˌɛskjuːˈɛl S-Q-L / 1,或“我的续集”/ maɪˈsiːkwəl /)是一个关系数据库管理系统(RDBMS)2 600万多个设施。MySQL表示“我的结构化查询语言”。该程序作为一个服务器，提供多用户访问多个数据库。
#2
11
PostgreSQL, SQLite, MySQL, MS SQL are just database management systems from different vendors
PostgreSQL、SQLite、MySQL和MS SQL只是来自不同供应商的数据库管理系统
#3
11
If you want to know about different dialects of SQL (Structured Query Language)
Have a look here :
如果您想了解SQL(结构化查询语言)的不同方言，请查看这里:
http://en.wikibooks.org/wiki/SQL_dialects_reference
http://en.wikibooks.org/wiki/SQL_dialects_reference
#5
3
PostgreSQL, SQLite, MySQL, MSSQL, Sybase = relational database management systems (RDBMSes).
PostgreSQL、SQLite、MySQL、MSSQL、Sybase =关系数据库管理系统(rdbms)。
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下工作。
#6
1
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.
不同的供应商=不同的想法和概念。就像其他编程问题一样……每个开发人员都有不同的解决方法，这很好。了解这些细微的差异，或者有时候是“搞砸了”，是件好事。
#1
15
SQL is Structured Query Language is a database computer language designed for managing data in relational database management systems (RDBMS).
SQL是结构化查询语言，是一种用于管理关系数据库管理系统(RDBMS)数据的数据库计算机语言。
PostgreSQL is an object-relational database management system (ORDBMS).1 It 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.
PostgreSQL是一个对象关系数据库管理系统(ORDBMS)。它是在bsd风格的许可下发布的，因此是免费的软件。和许多其他开源项目一样，PostgreSQL不是由任何一家公司控制的，而是有一个由开发者和公司组成的全球社区来开发它。
SQLite is 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.
SQLite是一个兼容acid的嵌入式关系数据库管理系统，包含在一个相对较小的(~225 KB1) C编程库中。SQLite的源代码属于公共领域。
MySQL (pronounced /maɪˌɛskjuːˈɛl/1 My S-Q-L, or "My sequel" /maɪˈsiːkwəl/) is a relational database management system (RDBMS)2 which has more than 6 million installations. 3 MySQL stands for "My Structured Query Language". The program runs as a server providing multi-user access to a number of databases.
MySQL(发音/ maɪˌɛskjuːˈɛl S-Q-L / 1,或“我的续集”/ maɪˈsiːkwəl /)是一个关系数据库管理系统(RDBMS)2 600万多个设施。MySQL表示“我的结构化查询语言”。该程序作为一个服务器，提供多用户访问多个数据库。
#2
11
PostgreSQL, SQLite, MySQL, MS SQL are just database management systems from different vendors
PostgreSQL、SQLite、MySQL和MS SQL只是来自不同供应商的数据库管理系统
#3
11
If you want to know about different dialects of SQL (Structured Query Language)
Have a look here :
如果您想了解SQL(结构化查询语言)的不同方言，请查看这里:
http://en.wikibooks.org/wiki/SQL_dialects_reference
http://en.wikibooks.org/wiki/SQL_dialects_reference
#4
#5
3
PostgreSQL, SQLite, MySQL, MSSQL, Sybase = relational database management systems (RDBMSes).
PostgreSQL、SQLite、MySQL、MSSQL、Sybase =关系数据库管理系统(rdbms)。
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下工作。
#6
1
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.
不同的供应商=不同的想法和概念。就像其他编程问题一样……每个开发人员都有不同的解决方法，这很好。了解这些细微的差异，或者有时候是“搞砸了”，是件好事。