TiDBとMySQLの互換性
1348 ワード
:TiDB 2.1.5
:MySQL 5.7.25
1.SQL
1.create table tablename as select * from t; (CTAS )
2. Savepoints
3.LOCK TABLE
4.CHECK TABLE
5.CHECKSUM TABLE
2. :
1. view
2. windows function
3. CTE(common table expression)
4. trigger
5. routing
6. function
7. event
8. fulltext index
9. Geospatical Index
10.XML
11. (foreign key)
12. X Protocol
13. (TEMPORARY TABLE)
14.
3. :
1.GROUP_CONCAT(.. order by a desc)
2. UUID_short()
2.JSNON
3. :
1.lower_case_table_names:
TiDB 2, , 1 2
MySQL 0,1,2. Linux 0,Windows 1,macOS 2
2.SQL_mode:
TiDB STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
MySQL NLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
3. :
TiDB: UTF8( utf8mb4), binary
MySQL:5.7 latin1, latin1_swedish_ci。
8.0 utf8mb4.
4. MySQL :
1. ID
2.
3.
4.
5.
参照先:https://pingcap.com/docs-cn/sql/mysql-compatibility/
https://pingcap.com/docs-cn/sql/json-functions/#unsupported-functions
https://github.com/pingcap/tidb/issues/7546
https://github.com/pingcap/tidb/issues/9499