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

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

SAVEPOINT <savepoint name>

Select语句

<select statement> ::=

<table expression>[ <into file clause> ]

[ FOR UPDATE | LOCK IN SHARE MODE ]

Select Into语句

<select into statement> ::=

<select clause><into clause>[ <from clause>[ <where clause> ][ <group by clause> ][ <having clause> ]

[ <select block tail> ] ]

<into clause> ::=

INTO <local variable> [ , <local variable> ]...

Set语句

为了避免不必要的重复定义，这里给出SET语句的两个定义。第一个定义为用户变量赋值；第二个定义为存储过程和存储函数的局部变量赋值。

<set statement> ::=

SET <user variable definition>

[ , <user variable definition> ]...<set statement> ::=

SET <local variable definition>

[ , <local variable definition> ]...<user variable definition> ::=

<user variable> { = | := } <scalar expression><local variable definition> ::=

<local variable> { = | := } <scalar expression>

Set Password语句

<set password statement> ::=

SET PASSWORD [ FOR <user name> ]

= PASSWORD( <password> )

Set Transaction语句

<set transaction statement> ::=

SET [ GLOBAL | SESSION ] TRANSACTION

ISOLATION LEVEL <isolation level>

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

616附录

<isolation level> ::=

READ UNCOMMITTED |READ COMMITTED |REPEATABLE READ |SERIALIZABLE

Show Character Set语句

<show character set statement> ::=

SHOW CHARACTER SET [ LIKE <alphanumeric literal> ]

Show Collation语句

<show collation statement> ::=

SHOW COLLATION [ LIKE <alphanumeric literal> ]

Show Column Types语句

<show column types statement> ::=

SHOW COLUMN TYPES

Show Columns语句

<show columns statement> ::=

SHOW [ FULL ] COLUMNS { FROM | IN } <table specification>[ { FROM | IN } <database name> ][ LIKE <alphanumeric literal> ]

Show Create Database语句

<show create database statement> ::=

SHOW CREATE DATABASE [ IF NOT EXISTS ] <database name>

Show Create Event语句

<show create event statement> ::=

SHOW CREATE EVENT [ <database name> . ] <event name>

Show Create Function语句

<show create function statement> ::=

SHOW CREATE FUNCTION

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

Show Create Procedure语句

<show create procedure statement> ::=

SHOW CREATE PROCEDURE

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

Show Create Table语句

<show create table statement> ::=

SHOW CREATE TABLE <table specification>

Show Create View语句

<show create view statement> ::=