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

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

[ <where clause> ] } |

{ DELETE [ LOW_PRIORITY ] [ IGNORE ]

FROM <table reference> [ , <table reference> ]ING <table reference> [ , <table reference> ]...[ <where clause> ] }

Describe语句

<describe statement> ::=

{ DESCRIBE | DESC } <table specification>

[ <column name> | <alphanumeric literal> ]

Do语句

<do statement> ::=

DO <scalar expression>

[ , <scalar expression> ]...

Drop Database语句

<drop database statement> ::=

DROP DATABASE [ IF NOT EXISTS ] <database name>

Drop Event语句

<drop event statement> ::=

DROP EVENT [ IF EXISTS ] [ <database name> .] <event name>

Drop Function语句

<drop function statement> ::=

DROP FUNCTION [ IF EXISTS ]

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

Drop Index语句

<drop index statement> ::=

DROP INDEX <index name> ON <table specification>

Drop Procedure语句

<drop procedure statement> ::=

DROP PROCEDURE [ IF EXISTS ]

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

Drop Table语句

<drop table statement> ::=

DROP [ TEMPORARY ] { TABLE | TABLES } [ IF EXISTS ]

<table specification> [ , <table specification> ]...[ CASCADE | RESTRICT ]

Drop Trigger语句

<drop trigger statement> ::=

DROP TRIGGER [ <table name> . ] <trigger name>