好的参考+ SQL数据库的特征/语法比较矩阵？ [英] Good reference + feature/syntax comparison matrix for SQL databases?
问题描述
我正在寻找一个参考指南可能性一个或多个比较矩阵为各种SQL数据库。目标是能够迅速地看到SQL标准的功能/操作符/语句（是的，复数将是好:)支持每个和它们使用的语法。
I am looking for a reference guide with possibility one or more comparison matrices for various SQL databases. The goal being to be able to see quickly what functions/operators/statements of the SQL standards (yes, plural would be good :) are supported by each and what syntax they use for them.
然后类似的其他功能，可能匹配他们与等效功能在其他数据库。
And then something similar for additional features as well, possibly matching them with equivalent features in other databases.
例如，我想能够快速查看数据库A，B，C是否支持 LIKE 运算符，如果它们都支持％ code> _ 占位符。
For instance, I'd like to be able to quickly see if database A, B, C support the LIKE operator and if they all support both the % and _ placeholders.
此类似问题中提到的几个RDBMS的维基百科比较提供了一些有趣的信息，但不是语法特征和运算符支持的程度。
This Wikipedia comparison of several RDBMS mentioned in similar questions gives some interesting info but not to the extent of the syntactic features and operator support.
最好是，我正在寻找至少包含以下表格的参考信息：
Preferably, I'm looking for a reference containing said info for at least the following tables:
- Oracle，
- PostgreSQL，
- DB2，
- HSQLDB，
- MS SQL，
- MySQL。
- Oracle,
- PostgreSQL,
- DB2,
- HSQLDB,
- MS SQL,
- MySQL.
过去没有找到合适的可用参考几天。
Haven't managed to find a good consolidated and usable reference for this over the past few days. Thanks.
推荐答案
我发现此参考资料非常有用：
I have found this reference very useful:
这篇关于好的参考+ SQL数据库的特征/语法比较矩阵？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
