- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide（InnoDB）
- Practical Tutorial
- Security White Paper
- Development Guide
- InnoDB
- Overview
- Use Limits
- Compatibility
- Connecting Database
- Join and Subquery
- Sequence
- Frequently Used DML Statements
- Read/Write Separation
- Distributed Transaction
- Creating Table
- Connection Protection
- Globally Unique Field
- Exporting/Importing Data
- Database Management Statements
- Passthrough SQL
- Preprocessing
- Subpartitioning
- Error Codes and Messages
- InnoDB
- API Documentation
- History
- Introduction
- API Category
- Security Group APIs
- Making API Requests
- TDSQL APIs
- ActiveHourDCDBInstance
- CancelDcnJob
- CloneAccount
- CloseDBExtranetAccess
- CopyAccountPrivileges
- CreateAccount
- CreateDedicatedClusterDCDBInstance
- DeleteAccount
- DescribeAccountPrivileges
- DescribeAccounts
- DescribeDBLogFiles
- DescribeDBParameters
- DescribeDBSlowLogs
- DescribeDBSyncMode
- DescribeDBTmpInstances
- DescribeDCDBInstanceNodeInfo
- DescribeDCDBInstances
- DescribeDCDBPrice
- DescribeDCDBShards
- DescribeDatabaseObjects
- DescribeDatabaseTable
- DescribeDatabases
- DescribeDcnDetail
- DescribeFileDownloadUrl
- DescribeFlow
- DescribeLogFileRetentionPeriod
- DescribeOrders
- DestroyDCDBInstance
- DestroyHourDCDBInstance
- GrantAccountPrivileges
- InitDCDBInstances
- IsolateDedicatedDBInstance
- IsolateHourDCDBInstance
- ModifyAccountDescription
- ModifyDBInstanceName
- ModifyDBInstancesProject
- ModifyDBParameters
- ModifyDBSyncMode
- ModifyInstanceVip
- ModifyInstanceVport
- ResetAccountPassword
- SwitchDBInstanceHA
- TerminateDedicatedDBInstance
- UpgradeDedicatedDCDBInstance
- UpgradeHourDCDBInstance
- CreateDCDBInstance
- CreateHourDCDBInstance
- DescribeDCDBInstanceDetail
- ModifyAccountConfig
- OpenDBExtranetAccess
- IsolateDCDBInstance
- Other APIs
- Data Types
- Error Codes
- FAQs
- General References
- Glossary
- Announcements
- Contact Us
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide（InnoDB）
- Practical Tutorial
- Security White Paper
- Development Guide
- InnoDB
- Overview
- Use Limits
- Compatibility
- Connecting Database
- Join and Subquery
- Sequence
- Frequently Used DML Statements
- Read/Write Separation
- Distributed Transaction
- Creating Table
- Connection Protection
- Globally Unique Field
- Exporting/Importing Data
- Database Management Statements
- Passthrough SQL
- Preprocessing
- Subpartitioning
- Error Codes and Messages
- InnoDB
- API Documentation
- History
- Introduction
- API Category
- Security Group APIs
- Making API Requests
- TDSQL APIs
- ActiveHourDCDBInstance
- CancelDcnJob
- CloneAccount
- CloseDBExtranetAccess
- CopyAccountPrivileges
- CreateAccount
- CreateDedicatedClusterDCDBInstance
- DeleteAccount
- DescribeAccountPrivileges
- DescribeAccounts
- DescribeDBLogFiles
- DescribeDBParameters
- DescribeDBSlowLogs
- DescribeDBSyncMode
- DescribeDBTmpInstances
- DescribeDCDBInstanceNodeInfo
- DescribeDCDBInstances
- DescribeDCDBPrice
- DescribeDCDBShards
- DescribeDatabaseObjects
- DescribeDatabaseTable
- DescribeDatabases
- DescribeDcnDetail
- DescribeFileDownloadUrl
- DescribeFlow
- DescribeLogFileRetentionPeriod
- DescribeOrders
- DestroyDCDBInstance
- DestroyHourDCDBInstance
- GrantAccountPrivileges
- InitDCDBInstances
- IsolateDedicatedDBInstance
- IsolateHourDCDBInstance
- ModifyAccountDescription
- ModifyDBInstanceName
- ModifyDBInstancesProject
- ModifyDBParameters
- ModifyDBSyncMode
- ModifyInstanceVip
- ModifyInstanceVport
- ResetAccountPassword
- SwitchDBInstanceHA
- TerminateDedicatedDBInstance
- UpgradeDedicatedDCDBInstance
- UpgradeHourDCDBInstance
- CreateDCDBInstance
- CreateHourDCDBInstance
- DescribeDCDBInstanceDetail
- ModifyAccountConfig
- OpenDBExtranetAccess
- IsolateDCDBInstance
- Other APIs
- Data Types
- Error Codes
- FAQs
- General References
- Glossary
- Announcements
- Contact Us
Feature Limits
Custom functions, events, and tablespaces are not supported
Views, stored procedures, triggers, and cursors are not supported
Foreign keys and self-built partitions are not supported
Compound statements such as BEGIN END,and LOOP are not supported
SQL syntax related to master/slave sync is not supported
Limits on small syntax
DDL
CREATE TABLE ... SELECT is not supported
CREATE TEMPORARY TABLE is not supported
CREATE/DROP/ALTER SERVER/LOGFILE GROUP are not supported
ALTER is not supported for renaming shardkey, but it can be used to change the type
DML
SELECT INTO OUTFILE/INTO DUMPFILE/INTO var_name are not supported
query_expression_options is not supported, such as HIGH_PRIORITY/STRAIGHT_JOIN/SQL_SMALL_RESULT/SQL_BIG_RESULT/SQL_BUFFER_RESULT/SQL_CACHE/SQL_NO_CACHE/SQL_CALC_FOUND_ROWS
INSERT/REPLACE without column name are not supported
ORDER BY/LIMIT cannot be used for global DELETE/UPDATE (Version greater than or equal to 1.14.4 can be supported)
UPDATE/DELETE without WHERE condition are not supported
LOAD DATA/XML are not supported
DELAYED/LOW_PRIORITY cannot be used in SQL statements
INSERT ... SELECT is not supported (Version greater than or equal to 1.14.4 can be supported)
References and operations on variables in SQL are not supported, such as SET @c=1, @d=@c+1; SELECT @c, @d
index_hint is not supported
HANDLER/DO are not supported
SQL management
ANALYZE/CHECK/CHECKSUM/OPTIMIZE/REPAIR TABLE are not supported, which should be performed with passthrough syntax
CACHE INDEX are not supported
FLUSH is not supported
KILL is not supported
LOAD INDEX INTO CACHE is not supported
RESET is not supported
SHUTDOWN is not supported
SHOW BINARY LOGS/BINLOG EVENTS is not supported
The combination of SHOW WARNINGS/ERRORS and LIMIT/COUNT is not supported
Other limits
Up to 5,000 tables can be created by default. If you need to create more tables, please submit a ticket.
Yes
No
Was this page helpful?