Chapter 13 SQL Statements第13章 SQL语句

Table of Contents目录

13.1 Data Definition Statements数据定义语句

13.1.1 Atomic Data Definition Statement Support原子数据定义语句支持

13.1.2 ALTER DATABASE Statement语句

13.1.3 ALTER EVENT Statement语句

13.1.4 ALTER FUNCTION Statement语句

13.1.5 ALTER INSTANCE Statement语句

13.1.6 ALTER LOGFILE GROUP Statement语句

13.1.7 ALTER PROCEDURE Statement语句

13.1.8 ALTER SERVER Statement语句

13.1.9 ALTER TABLE Statement语句

13.1.10 ALTER TABLESPACE Statement语句

13.1.11 ALTER VIEW Statement语句

13.1.12 CREATE DATABASE Statement语句

13.1.13 CREATE EVENT Statement语句

13.1.14 CREATE FUNCTION Statement语句

13.1.15 CREATE INDEX Statement语句

13.1.16 CREATE LOGFILE GROUP Statement语句

13.1.17 CREATE PROCEDURE and CREATE FUNCTION StatementsCREATE PROCEDURE语句和CREATE FUNCTION语句

13.1.18 CREATE SERVER Statement语句

13.1.19 CREATE SPATIAL REFERENCE SYSTEM Statement语句

13.1.20 CREATE TABLE Statement语句

13.1.21 CREATE TABLESPACE Statement语句

13.1.22 CREATE TRIGGER Statement语句

13.1.23 CREATE VIEW Statement语句

13.1.24 DROP DATABASE Statement语句

13.1.25 DROP EVENT Statement语句

13.1.26 DROP FUNCTION Statement语句

13.1.27 DROP INDEX Statement语句

13.1.28 DROP LOGFILE GROUP Statement语句

13.1.29 DROP PROCEDURE and DROP FUNCTION StatementsDROP PROCEDURE语句DROP FUNCTION语句

13.1.30 DROP SERVER Statement语句

13.1.31 DROP SPATIAL REFERENCE SYSTEM Statement语句

13.1.32 DROP TABLE Statement语句

13.1.33 DROP TABLESPACE Statement语句

13.1.34 DROP TRIGGER Statement语句

13.1.35 DROP VIEW Statement语句

13.1.36 RENAME TABLE Statement语句

13.1.37 TRUNCATE TABLE Statement语句

13.2 Data Manipulation Statements数据操作语句

13.2.1 CALL Statement语句

13.2.2 DELETE Statement语句

13.2.3 DO Statement语句

13.2.4 HANDLER Statement语句

13.2.5 IMPORT TABLE Statement语句

13.2.6 INSERT Statement语句

13.2.7 LOAD DATA Statement语句

13.2.8 LOAD XML Statement语句

13.2.9 REPLACE Statement语句

13.2.10 SELECT Statement语句

13.2.11 Subqueries子查询

13.2.12 TABLE Statement语句

13.2.13 UPDATE Statement语句

13.2.14 VALUES Statement语句

13.2.15 WITH (Common Table Expressions)（公共表表达式）

13.3 Transactional and Locking Statements事务和锁定语句

13.3.1 START TRANSACTION, COMMIT, and ROLLBACK StatementsSTART TRANSACTION语句、COMMIT语句和ROLLBACK语句

13.3.2 Statements That Cannot Be Rolled Back无法回滚的语句

13.3.3 Statements That Cause an Implicit Commit导致隐式提交的语句

13.3.4 SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT StatementsSAVEPOINT语句、ROLLBACK TO SAVEPOINT语句和RELEASE SAVEPOINT语句

13.3.5 LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE StatementsLOCK INSTANCE FOR BACKUP语句和UNLOCK INSTANCE语句

13.3.6 LOCK TABLES and UNLOCK TABLES StatementsLOCK TABLES语句和UNLOCK TABLES语句

13.3.7 SET TRANSACTION Statement语句

13.3.8 XA TransactionsXA事务

13.4 Replication Statements复制语句

13.4.1 SQL Statements for Controlling Source Servers用于控制源服务器的SQL语句

13.4.2 SQL Statements for Controlling Replica Servers用于控制副本服务器的SQL语句

13.4.3 SQL Statements for Controlling Group Replication用于控制组复制的SQL语句

13.5 Prepared Statements准备好的报表

13.5.1 PREPARE Statement语句

13.5.2 EXECUTE Statement语句

13.5.3 DEALLOCATE PREPARE Statement语句

13.6 Compound Statement Syntax复合语句语法

13.6.1 BEGIN ... END Compound Statement合成语句

13.6.2 Statement Labels语句标签

13.6.3 DECLARE Statement语句

13.6.4 Variables in Stored Programs存储程序中的变量

13.6.5 Flow Control Statements流量控制语句

13.6.6 Cursors游标

13.6.7 Condition Handling条件处理

13.6.8 Restrictions on Condition Handling条件处理限制

13.7 Database Administration Statements数据库管理语句

13.7.1 Account Management Statements账户管理报表

13.7.2 Resource Group Management Statements资源组管理语句

13.7.3 Table Maintenance Statements表维护报表

13.7.4 Component, Plugin, and Loadable Function Statements组件、插件和可加载函数语句

13.7.5 CLONE Statement语句

13.7.6 SET Statements语句

13.7.7 SHOW Statements语句

13.7.8 Other Administrative Statements其他行政报表

13.8 Utility Statements实用程序语句

13.8.1 DESCRIBE Statement语句

13.8.2 EXPLAIN Statement语句

13.8.3 HELP Statement语句

13.8.4 USE Statement语句