未命名

Size: px

Start display at page:

Download "未命名"

伊奖栾
5 years ago
Views:

$附录三 ADS- MySQL 基础语法偏表类别语法偏类 MySQL 语法 ADS 语法备注型 Utility DESCRIBE {DESCRIBE DESC} tbl_name [col_name wild] {DESCRIBE DESC} dbname.$

1 附录三 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 使用手册

2 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 使用手册

3 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 使用手册

4 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 使用手册

5 (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 使用手册

6 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 版本以上开始支持 DO HANDLER INSERT 负偏 INSERT [LOW_PRIORITY DELAYED HIGH_PRIORITY] [IGNORE] [INTO] tbl_name INSERT [IGNORE] INTO tbl_name [(col_name,...)] {VALUES ADS 版本以上开始支持 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 使用手册

7 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 使用手册

8 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 使用手册

9 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 使用手册

學科 100% ( 為單複選題, 每題 2.5 分, 共 100 分 ) 1. 請參閱附圖作答 : (A) 選項 A (B) 選項 B (C) 選項 C (D) 選項 D Ans:D 2. 下列對於資料庫正規化 (Normalization) 的敘

學科 100% ( 為單複選題, 每題 2.5 分, 共 100 分 ) 1. 請參閱附圖作答 : (A) 選項 A (B) 選項 B (C) 選項 C (D) 選項 D Ans:D 2. 下列對於資料庫正規化 (Normalization) 的敘 ITE 資訊專業人員鑑定資料庫系統開發與設計實務試卷編號 :IDS101 注意事項一本測驗為單面印刷試題, 共計十三頁第二至十三頁為四十道學科試題, 測驗時間 90 分鐘 : 每題 2.5 分, 總測驗時間為 90 分鐘二執行 CSF 測驗系統 -Client