Oracle 5.0, Справочное руководство

Страница: 10 / 3232

MySQL 5.0 Reference Manual
x
13.1. Data Definition Statements ...................................................................................... 1012
13.1.1.
ALTER DATABASE
Syntax ........................................................................... 1012
13.1.2.
ALTER FUNCTION
Syntax ........................................................................... 1012
13.1.3.
ALTER PROCEDURE
Syntax ......................................................................... 1013
13.1.4.
ALTER TABLE
Syntax ................................................................................. 1013
13.1.5.
ALTER VIEW
Syntax ................................................................................... 1020
13.1.6.
CREATE DATABASE
Syntax ......................................................................... 1020
13.1.7.
CREATE FUNCTION
Syntax ......................................................................... 1021
13.1.8.
CREATE INDEX
Syntax ............................................................................... 1021
13.1.9.
CREATE PROCEDURE
and
CREATE FUNCTION
Syntax .................................. 1023
13.1.10.
CREATE TABLE
Syntax ............................................................................. 1029
13.1.11.
CREATE TRIGGER
Syntax ......................................................................... 1047
13.1.12.
CREATE VIEW
Syntax ............................................................................... 1050
13.1.13.
DROP DATABASE
Syntax ........................................................................... 1054
13.1.14.
DROP FUNCTION
Syntax ........................................................................... 1055
13.1.15.
DROP INDEX
Syntax ................................................................................. 1055
13.1.16.
DROP PROCEDURE
and
DROP FUNCTION
Syntax ........................................ 1056
13.1.17.
DROP TABLE
Syntax ................................................................................. 1056
13.1.18.
DROP TRIGGER
Syntax ............................................................................. 1056
13.1.19.
DROP VIEW
Syntax ................................................................................... 1057
13.1.20.
RENAME TABLE
Syntax ............................................................................. 1057
13.1.21.
TRUNCATE TABLE
Syntax ......................................................................... 1058
13.2. Data Manipulation Statements ................................................................................. 1059
13.2.1.
CALL
Syntax ................................................................................................ 1059
13.2.2.
DELETE
Syntax ............................................................................................ 1060
13.2.3.
DO
Syntax .................................................................................................... 1064
13.2.4.
HANDLER
Syntax .......................................................................................... 1064
13.2.5.
INSERT
Syntax ............................................................................................ 1065
13.2.6.
LOAD DATA INFILE
Syntax ....................................................................... 1072
13.2.7.
REPLACE
Syntax .......................................................................................... 1081
13.2.8.
SELECT
Syntax ............................................................................................ 1082
13.2.9. Subquery Syntax .......................................................................................... 1098
13.2.10.
UPDATE
Syntax .......................................................................................... 1108
13.3. MySQL Transactional and Locking Statements ......................................................... 1110
13.3.1.
START TRANSACTION
,
COMMIT
, and
ROLLBACK
Syntax ............................... 1110
13.3.2. Statements That Cannot Be Rolled Back ....................................................... 1113
13.3.3. Statements That Cause an Implicit Commit ................................................... 1113
13.3.4.
SAVEPOINT
,
ROLLBACK TO SAVEPOINT
, and
RELEASE SAVEPOINT
, and
Syntax .................................................................................................................... 1114
13.3.5.
LOCK TABLES
and
UNLOCK TABLES
Syntax ................................................ 1114
13.3.6.
SET TRANSACTION
Syntax ......................................................................... 1119
13.3.7. XA Transactions .......................................................................................... 1121
13.4. Replication Statements ........................................................................................... 1125
13.4.1. SQL Statements for Controlling Master Servers ............................................. 1125
13.4.2. SQL Statements for Controlling Slave Servers ............................................... 1127
13.5. SQL Syntax for Prepared Statements ...................................................................... 1133
13.5.1.
PREPARE
Syntax .......................................................................................... 1136
13.5.2.
EXECUTE
Syntax .......................................................................................... 1136
13.5.3.
DEALLOCATE PREPARE
Syntax ................................................................... 1136
13.6. MySQL Compound-Statement Syntax ...................................................................... 1137
13.6.1.
BEGIN ... END
Compound-Statement Syntax ............................................ 1137
13.6.2. Statement Label Syntax ............................................................................... 1137
13.6.3.
DECLARE
Syntax .......................................................................................... 1138
13.6.4. Variables in Stored Programs ....................................................................... 1138
13.6.5. Flow Control Statements .............................................................................. 1140
13.6.6. Cursors ....................................................................................................... 1144
13.6.7. Condition Handling ....................................................................................... 1145
13.7. Database Administration Statements ........................................................................ 1149