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

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

Optimize Table语句

<optimize table statement> ::=

OPTIMIZE [ <optimize option> ]

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

Prepare语句

<prepare statement> ::=

PREPARE <statement name>

FROM { <alphanumeric literal> | <user variable> }

Rename Table语句

<rename table statement> ::=

RENAME { TABLE | TABLES } <table name change>

[ , <table name change> ]...<table name change> ::= <table name> TO <table name>

Rename User语句

<rename user statement> ::=

RENAME USER <user name> TO <user name>

[ , <user name> TO <user name> ]...

Repair Table语句

<repair table statement> ::=

REPAIR [ <repair option> ]

TABLE <table specification> [ , <table specification> ]...[ QUICK ] [ EXTENDED ] [ USE_FRM ]<repair option> ::= NO_WRITE_TO_BINLOG | LOCAL

Repeat语句

<repeat statement> ::=

[ <label> : ] REPEAT <statement list>UNTIL <condition>END REPEAT <label>

Replace语句

<replace statement> ::=

REPLACE [ DELAYED | LOW_PRIORITY] [ IGNORE ][ IGNORE ] [ INTO ] <table specification><insert specification>

Restore Table语句

<restore table statement> ::=

RESTORE TABLE <table specification>

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

614附录

[ , <table specification> ]...FROM <directory>

Return语句

<return statement> ::=

RETURN <scalar expression>

Revoke语句

<revoke statement> ::=

<revoke table privilege statement> |<revoke database privilege statement> |<revoke user privilege statement> |<revoke execute privilege statement> |<revoke event privilege statement>

<revoke table privilege statement> ::=

REVOKE [ <table privileges> ] [ GRANT OPTION ]ON <table specification>

FROM <user name> [ , <user name> ]...<revoke database privilege statement> ::=

REVOKE [ <database privileges> ] [ GRANT OPTION ]ON [ <database name> . ] *

FROM <user name> [ , <user name> ]...<revoke user privilege statement> ::=

REVOKE [ <user privileges> ] [ GRANT OPTION ]ON *.*

FROM <user name> [ , <user name> ]...<revoke execute privilege statement> ::=

REVOKE EXECUTE

ON { PROCEDURE <stored procedure name> |

FUNCTION <stored function name> }

FROM <grantees><revoke event privilege statement> ::=

REVOKE EVENT

ON [ <database name> . | *. ] *FROM <grantees>

Rollback语句

<rollback statement> ::=

ROLLBACK [ WORK ] [ AND [ NO ] CHAIN ] [ [ NO ] RELEASE ][ TO SAVEPOINT <savepoint name> ]

Savepoint语句

<savepoint statement> ::=