Structsยง
- Alter
Database Statement - parse
ALTER {DATABASE | SCHEMA} [db_name] alter_option ...
- Alter
Table Statement - parse
ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options]
- Create
Index Statement - parse
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
- Create
Table Statement - CreateTableStatement MySQL Doc
- Drop
Database Statement - DROP {DATABASE | SCHEMA} [IF EXISTS] db_name
- Drop
Event Statement - parse
DROP EVENT [IF EXISTS] event_name
- Drop
Function Statement - parse
DROP FUNCTION [IF EXISTS] sp_name
- Drop
Index Statement - parse
DROP INDEX index_name ON tbl_name [algorithm_option | lock_option] ...
- Drop
Logfile Group Statement - parse
DROP LOGFILE GROUP logfile_group ENGINE [=] engine_name
- Drop
Procedure Statement - parse
DROP PROCEDURE [IF EXISTS] sp_name
- Drop
Server Statement - parse
DROP SERVER [ IF EXISTS ] server_name
- Drop
Spatial Reference System Statement - parse
DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid
- Drop
Table Statement - parse
DROP [TEMPORARY] TABLE [IF EXISTS] tbl_name [, tbl_name] ... [RESTRICT | CASCADE]
- Drop
Tablespace Statement - parse
DROP [UNDO] TABLESPACE tablespace_name [ENGINE [=] engine_name]
- Drop
Trigger Statement - parse
DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name
- Drop
View Statement - parse
DROP VIEW [IF EXISTS] view_name [, view_name] ... [RESTRICT | CASCADE]
- Rename
Table Statement - parse
RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ...
- Truncate
Table Statement - parse
TRUNCATE [TABLE] tbl_name