附录三 ADS- MySQL 基础语法偏表 类别语法偏类 MySQL 语法 ADS 语法备注 型 Utility DESCRIBE {DESCRIBE DESC} tbl_name [col_name wild] {DESCRIBE DESC} dbname.tbl_name EXPLAIN 负偏 {EXPLAIN} [explain_type] explainable_stmt {EXPLAIN} explainable_stmt EXPLAIN 返回与 MySQL 不同 USE 无偏 USE dbname USE dbname HELP 负偏 HELP 'search_string' 暂不 支持 DBAdmin SET SET variable_assignment [, SET GLOBAL LOCAL ADS 不完整 variable_assignment] variable_assignment [, 支持全部 variable_assignment] MySQL 变 量 AUTHORS BINARY LOGS BINLOG EVENTS CHARACTER SET COLLATION 负偏 COLLATION [LIKE COLLATION 'pattern' WHERE expr] COLUMNS CONTRIBUTORS DATABASE EVENT FUNCTION 87 分析数据库服务 ADS 使用手册
PROCEDURE TABLE TRIGGER VIEW DATABASES {DATABASES SCHEMAS} [LIKE 'pattern' WHERE expr] {DATABASES} [LIKE 'pattern' ] [extra] ENGINE ENGINES ERRORS EVENTS FUNCTION CODE FUNCTION STATUS GRANTS GRANTS [FOR user] GRANTS [FOR user] ON [object_type] privilege_level INDEX MASTER STATUS OPEN TABLES PLUGINS PRIVILEGES PROCEDURE CODE PROCEDURE 88 分析数据库服务 ADS 使用手册
STATUS PROCESSLIST PROFILE PROFILES RELAYLOG EVENTS SLAVE HOSTS SLAVE STATUS STATUS 负偏 [GLOBAL SESSION] STATUS [LIKE 'pattern' WHERE expr] [GLOBAL SESSION] STATUS [LIKE 'pattern'] 不同权限下 可 用语法不 同 TABLE STATUS TABLES [FULL] TABLES TABLES {IN FROM} [{FROM IN} db_name] [LIKE db_name[.tablegroup_name] 'pattern' WHERE expr] TRIGGERS VARIABLES 负偏 [GLOBAL SESSION] VARIABLES [LIKE 'pattern' WHERE expr] [GLOBAL SESSION] VARIABLES [LIKE 'pattern'] 不同权限下 可 用语法不 同 WARNINGS TABLEGROUPS 正偏 无 TABLEGROUPS IN db_name LIST USERS 正偏 无 LIST USERS [IN db_name] CREATE USER CREATE USER ADD USER username ON user_specification db_name.* [, user_specification] DROP USER DROP USER user [, user] REMOVE USER username ON db_name.* DDL ALTER DATABASE 89 分析数据库服务 ADS 使用手册
ALTER EVENT ALTER LOGFILE GROUP ALTER FUNCTION ALTER PROCEDURE ALTER SERVER ALTER TABLE ALTER [IGNORE] TABLE ALTER TABLE tbl_name tbl_name [alter_specification [, [add]{index column} alter_specification]...] [index_options cloumn_options [partition_options] ] ALTER TABLESPACE ALTER VIEW CREATE 负偏 CREATE {DATABASE CREATE DATABESE 公有云上不 DATABASE SCHEMA} [IF NOT EXISTS] db_name 允许 用户通 db_name [create_specification] 过命令建 立 [create_specification] DB CREATE EVENT CREATE FUNCTION CREATE INDEX CREATE LOGFILE GROUP CREATE PROCEDURE and CREATE FUNCTION CREATE SERVER CREATE TABLE CREATE [TEMPORARY] CREATE [DIMENTION] 详 见使 用 手 TABLE [IF NOT EXISTS] TABLE tbl_name 册 3.3 节 tbl_name [(create_definition,...)] {[(create_definition,...)] [partition_options] [table_options] [table_options] [partition_options] [tablegoup_options] select_statement { LIKE old_tbl_name 90 分析数据库服务 ADS 使用手册
(LIKE old_tbl_name) }} CREATE TABLESPACE CREATE TRIGGER CREATE VIEW DROP DATABASE 负偏 DROP {DATABASE DROP DATABASE db_name SCHEMA} [IF EXISTS] db_name DROP EVENT DROP FUNCTION DROP INDEX DROP LOGFILE GROUP DROP PROCEDURE and DROP FUNCTION DROP SERVER DROP TABLE DROP [TEMPORARY] TABLE DROP TABLE tbl_name [IN [IF EXISTS] tablegroup_name] tbl_name [, tbl_name]... [RESTRICT CASCADE] DROP TABLESPACE DROP TRIGGER DROP VIEW RENAME TABLE TRUNCATE TABLE CREATE TABLEGROUP 正偏 无 CREATE TABLEGROUP db_name.tablegroup_name [options] 91 分析数据库服务 ADS 使用手册
ALTER TABLEGROUP 正偏 无 ALTER TABLEGROUP db_name.tablegroup_name key=value DROP TABLEGROUP 正偏 无 DROP TABLEGROUP db_name.tablegroup_name DML CALL DELETE 负偏 DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name (partition_name,...)] [WHERE where_condition] [ORDER BY...] [LIMIT row_count] DELETE FROM tbl_name WHERE where_condition ADS 0.7.0 版本以上开 始 支持 DO HANDLER INSERT 负偏 INSERT [LOW_PRIORITY DELAYED HIGH_PRIORITY] [IGNORE] [INTO] tbl_name INSERT [IGNORE] INTO tbl_name [(col_name,...)] {VALUES ADS 0.7.0 版本以上开 始 支持 VALUE} col_name=expr (partition_name,...)] [, col_name=expr]... ] [(col_name,...)] {VALUES VALUE} ({expr DEFAULT},...),(...),... [ ON DUPLICATE KEY UPDATE col_name=expr [, col_name=expr]... ] 92 分析数据库服务 ADS 使用手册
LOAD DATA LOAD DATA LOAD DATA FROM [LOW_PRIORITY 'sourcepath' CONCURRENT] [LOCAL] [IN VERSION dataversion] INFILE 'file_name' [OVERWRITE] INTO TABLE [REPLACE IGNORE] tablename INTO TABLE tbl_name (partition_name,...)] (partition_name,...)] [CHARACTER SET charset_name] [{FIELDS COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number {LINES ROWS}] [(col_name_or_user_var,... )] [SET col_name = expr,...] LOAD XML REPLACE 93 分析数据库服务 ADS 使用手册
SELECT 负偏 SELECT [ALL DISTINCT DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr...] [FROM table_references partition_list] [WHERE where_condition] [GROUP BY {col_name expr position} [ASC DESC],... [WITH ROLLUP]] [HAVING where_condition] [ORDER BY {col_name expr position} [ASC DESC],...] [LIMIT {[offset,] row_count row_count OFFSET offset}] [PROCEDURE procedure_name(argument_lis t)] [INTO OUTFILE 'file_name' [CHARACTER SET charset_name] export_options INTO DUMPFILE 'file_name' INTO var_name [, var_name]] [FOR UPDATE LOCK IN SHARE MODE]] SELECT [DISTINCT] select_expr [, select_expr...] FROM table_references [JOIN {table_reference}] [WHERE filter_condition] [GROUP BY {col_name expr position} [HAVING having_condition]] [ORDER BY {col_name expr position} [ASC DESC],...] [LIMIT {row_count}] 详 见使 用 手 册 4.1 节 94 分析数据库服务 ADS 使用手册
UPDATE 请使 用 insert+delet e 代替 Transactio nal and 全部负偏略不 支持 ADS 不 支持 事务 Locking Prepared Statement s 全部负偏略不 支持 ADS 目前不 支持服务端 的 Prepared Statements Compoun d-stateme nt and Stored Programs 全部 负偏 略 不 支持 ADS 目前不 支持存储过程和函数声明, 未来计 划 支持 95 分析数据库服务 ADS 使用手册