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

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

ON { PROCEDURE <stored procedure name> |

FUNCTION <stored function name> }

TO <grantees>

[ WITH <grant option>... ]

Handler Close语句

<handler close statement> ::=

HANDLER <handler name> CLOSE

Handler Open语句

<handler open statement> ::=

HANDLER <table specification> OPEN [ As <handler name> ]

Handler Read语句

<handler read statement> ::=

HANDLER <handler name> READ <read specification>

[ <where clause> ][ <limit clause> ]

<read specification> ::=

FIRST |NEXT |{ <index name> { FIRST | NEXT | PREV | LAST } } |{ <index name> { = | > | >= | <= | < }

<scalar expression list> }

Help语句

<help statement> ::=

HELP <alphanumeric literal>

If语句

<if statement> ::=

IF <condition> THEN <statement list>

[ ELSEIF <condition> THEN <statement list>]...[ ELSE <statement list> ]END IF

Insert语句

<insert statement> ::=

INSERT [ DELAYED | LOW_PRIORITY | HIGH_PRIORITY ]

[ IGNORE ] [ INTO ] <table specification>

<insert specification> [ <on duplicate key specification> ]

<on duplicate key specification> ::=

ON DUPLICATE KEY UPDATE <column assignment>

[ , <column assignment> ]...

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

612附录

Iterate语句

<iterate statement> ::=

ITERATE <label>

Leave语句

<leave statement> ::=

LEAVE <label>

Load语句

<load statement> ::=

LOAD DATA [ LOW_PRIORITY ] [ CONCURRENT ] [ LOCAL ]

INFILE '<file name>'[ REPLACE | IGNORE ]

INTO TABLE <table specification>[ <fields specification> ][ <lines specification> ]

[ IGNORE <whole number> LINES ]

[ { <column name> | <user variable> }

[ , { <column name> | <user variable> } ]... ][ <set statement> ]

<fields specification> ::=

FIELDS [ TERMINATED BY <alphanumeric literal> ]

[ [ OPTIONALLY ] ENCLOSED BY <alphanumeric literal> ][ ESCAPED BY <alphanumeric literal> ]<lines specification> ::=

LINES [ TERMINATED BY <alphanumeric literal> ]

[ STARTING BY <alphanumeric literal> ]

Lock Table语句

<lock table statement> ::=

LOCK { TABLE | TABLES } <lock table> [ ,<lock table> ]...<lock table> ::=

<table specification> [ AS <pseudonym> ]<lock type><lock type> ::= READ | READ LOCAL | WRITE |LOW_PRIORITY WRITE

Loop语句

<loop statement> ::=

[ <label> : ] LOOP <statement list>END LOOP [ <label> ]

Open Cursor语句

<open cursor statement> ::=

OPEN <cursor name>