tencent cloud

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.