MySQL开发者SQL权威指南-附录(6)

MySQL开发者SQL权威指南的附录文档

DCL语句

<dcl statement> ::=

<alter user statement> |<create user statement> |<drop user statement> |<grant statement> |<rename user statement> |<set password statement> |<revoke statement>

Procedural语句

<procedural statement> ::=

<begin-end block> |<call statement> |<declare condition statement> |<declare cursor statement> |<declare handler statement> |<declare variable statement> |<flow control statement> |<return statement>

Flow-Control语句

<flow control statement> ::=

<case statement> |<if statement> |<iterate statement> |<leave statement> |<loop statement> |<repeat statement> |<while statement>

Informative语句

<informative statement> ::=

<describe statement> |<help statement> |<show statement>

Table Maintenance语句

<table maintenance statement> ::=

<analyze table statement> |<backup table statement> |<checksum table statement> |<check table statement> |<optimize table statement> |<repair table statement> |<restore table statement>

MySQL开发者SQL权威指南的附录文档

604附录

A.4.2 SQL语句的定义

Alter Database语句

<alter database statement> ::=

ALTER DATABASE [ <database name> ]

[ <database option>... ]

Alter Event语句

<alter event statement> ::=

ALTER EVENT [ <database name> . ] <event name>

ON SCHEDULE <event schedule>[ RENAME TO <event name> ]

[ ON COMPLETION [ NOT ] PRESERVE ][ ENABLE | DISABLE ]

[ COMMENT <alphanumeric literal> ]DO <sql statement>

Alter Function语句

<alter function statement> ::=

ALTER FUNCTION [ <database name> . ] <stored function name>

[ <routine characteristic>... ]

Alter Procedure语句

<alter procedure statement> ::=

ALTER PROCEDURE [ <database name> . ] <stored procedure name>

[ <routine characteristic>... ]

Alter Table Statement

<alter table statement> ::=

ALTER [ IGNORE ] TABLE <table specification>

<table structure change>

Alter View语句

<alter view statement> ::=

ALTER

[ <definer option> ]

[ <sql security option> ]

[ ALGORITHM = { MERGE | TEMPTABLE UNDEFINED } ]

VIEW <view name> [ <column list> ] AS<table expression>[ WITH [ CASCADED | LOCAL ] CHECK OPTION ]

Analyze Table语句

<analyze table statement> ::=

ANALYZE [ <analyze option> ]

TABLE <table specification> [ , <table specification> ]...<analyze option> ::= NO_WRITE_TO_BINLOG | LOCAL