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

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

Backup Table语句

<backup table statement> ::=

BACKUP TABLE <table specification>

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

Begin Work语句

<begin work statement> ::=

BEGIN WORK

Call语句

<call statement> ::=

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

( [ <scalar expression> [ , <scalar expression> ]... ] )

Case语句

<case statement> ::=

{ CASE <scalar expression>

WHEN <scalar expression> THEN <statemen list>

[ WHEN <scalar expression> THE <statement list> ]...[ ELSE <statement list> ]END CASE } |{ CASE

WHEN <condition> THEN <statement list>

[ WHEN <condition> THEN <statement list>]...[ ELSE <statement list>END CASE }

Checksum Table语句

<checksum table statement> ::=

CHECKSUM TABLE <table specification>

[ , <table specification> ]...[ <checksum option> ]<checksum option> ::= QUICK | EXTENDED

Check Table语句

<check table statement> ::=

CHECK TABLE <table specification> [ <tablespecification> ]...

[ <check option> ]...<check option> ::=

FOR UPGRADE | QUICK | FAST | MEDIUM EXTENDED | CHANGED

Close Cursor语句

<close cursor statement> ::=

CLOSE <cursor name>

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

606附录

Commit语句

<commit statement> ::=

COMMIT [ WORK ] [ AND [ NO ] CHAIN ] [ [ NO ] RELEASE ]

Create Database语句

<create database statement> ::=

CREATE DATABASE [ IF NOT EXISTS ] <database name>

[ <database option>... ]

Create Event语句

<create event statement> ::=

CREATE EVENT [ IF NOT EXISTS ]

[ <database name> . ] <event name>ON SCHEDULE <event schedule>[ ON COMPLETION [ NOT ] PRESERVE ][ ENABLE | DISABLE ]

[ COMMENT <alphanumeric literal> ]DO <event action>

<event action> ::=

<declarative sql statement> |<begin-end block>

Create Function语句

<create function statement> ::=

CREATE [ <definer option> ]

FUNCTION [ <database name> . ] <stored function name>( [ <parameter list> ] )RETURNS <data type>

[ <routine characteristic>... ]<routine body>

Create Index语句

<create index statement> ::=

CREATE [ <index type> ] INDEX <index name>[ USING { BTREE | HASH } ]ON <table specification>

( <column in index> [ , <column in index> ]... )

Create Procedure语句

<create procedure statement> ::=

CREATE [<definer option> ]

PROCEDURE <stored procedure name> ( [<parameter list> ] )[ <routine characteristic>... ]<routine body>