mysql语句语法

admin 2012年11月22日 Mysql 暂无评论 1,158 浏览

Table of Contents

13.1. Data Definition Statements - 数据定义语句

13.1.1. ALTER DATABASE Syntax
13.1.2. ALTER EVENT Syntax
13.1.3. ALTER LOGFILE GROUP Syntax
13.1.4. ALTER FUNCTION Syntax
13.1.5. ALTER PROCEDURE Syntax
13.1.6. ALTER SERVER Syntax
13.1.7. ALTER TABLE Syntax
13.1.8. ALTER TABLESPACE Syntax
13.1.9. ALTER VIEW Syntax
13.1.10. CREATE DATABASE Syntax
13.1.11. CREATE EVENT Syntax
13.1.12. CREATE FUNCTION Syntax
13.1.13. CREATE INDEX Syntax
13.1.14. CREATE LOGFILE GROUP Syntax
13.1.15. CREATE PROCEDURE and CREATE FUNCTION Syntax
13.1.16. CREATE SERVER Syntax
13.1.17. CREATE TABLE Syntax
13.1.18. CREATE TABLESPACE Syntax
13.1.19. CREATE TRIGGER Syntax
13.1.20. CREATE VIEW Syntax
13.1.21. DROP DATABASE Syntax
13.1.22. DROP EVENT Syntax
13.1.23. DROP FUNCTION Syntax
13.1.24. DROP INDEX Syntax
13.1.25. DROP LOGFILE GROUP Syntax
13.1.26. DROP PROCEDURE and DROP FUNCTION Syntax
13.1.27. DROP SERVER Syntax
13.1.28. DROP TABLE Syntax
13.1.29. DROP TABLESPACE Syntax
13.1.30. DROP TRIGGER Syntax
13.1.31. DROP VIEW Syntax
13.1.32. RENAME TABLE Syntax
13.1.33. TRUNCATE TABLE Syntax

13.2. Data Manipulation Statements -数据操作语句

13.2.1. CALL Syntax
13.2.2. DELETE Syntax
13.2.3. DO Syntax
13.2.4. HANDLER Syntax
13.2.5. INSERT Syntax
13.2.6. LOAD DATA INFILE Syntax
13.2.7. LOAD XML Syntax
13.2.8. REPLACE Syntax
13.2.9. SELECT Syntax
13.2.10. Subquery Syntax子查询语法
13.2.11. UPDATE Syntax

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

13.3.1. START TRANSACTION, COMMIT, and ROLLBACK Syntax
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, and Syntax
13.3.5. LOCK TABLES and UNLOCK TABLES Syntax
13.3.6. SET TRANSACTION Syntax
13.3.7. XA Transactions 分布式事务处理

13.4. Replication Statements - 复制语句

13.4.1. SQL Statements for Controlling Master Servers 控制主服务器的SQL语句
13.4.2. SQL Statements for Controlling Slave Servers控制从服务器的SQL语句

13.5. SQL Syntax for Prepared Statements - 预准备语句的 SQL 语法

13.5.1. PREPARE Syntax
13.5.2. EXECUTE Syntax
13.5.3. DEALLOCATE PREPARE Syntax
13.5.4. Automatic Prepared Statement Repreparation--------------？？

13.6. MySQL Compound-Statement Syntax - MySQL 复合语句语法

13.6.1. BEGIN ... END Compound-Statement Syntax BEGIN ... END 复合语句语法
13.6.2. Statement Label Syntax语句标签语法
13.6.3. DECLARE Syntax
13.6.4. Variables in Stored Programs在存储程序中的变量
13.6.5. Flow Control Statements流控制语句
13.6.6. Cursors 游标
13.6.7. Condition Handling条件处理

13.7. Database Administration Statements - 数据库管理语句

13.7.1. Account Management Statements帐户管理语句
13.7.2. Table Maintenance Statements表维护语句
13.7.3. Plugin and User-Defined Function Statements插件和用户自定义函数语句
13.7.4. SET Syntax
13.7.5. SHOW Syntax
13.7.6. Other Administrative Statements其它管理语句

13.8. MySQL Utility Statements- MySQL 实用程序语句

13.8.1. DESCRIBE Syntax
13.8.2. EXPLAIN Syntax
13.8.3. HELP Syntax
13.8.4. USE Syntax

相关博文

mysql语句语法

标签: Mysql