Articles on the various CREATE statements
-
CREATE DATABASE
Syntax: CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_specification] ... cr -
CREATE EVENT
Syntax: CREATE [DEFINER = { user | CURRENT_USER }] EVENT [IF NOT EXISTS] -
CREATE FUNCTION
Syntax: CREATE [DEFINER = {user | CURRENT_USER}] FUNCTION func_name ([func_paramet -
CREATE INDEX
Syntax: {{{ CREATE [ONLINE|OFFLINE] [UNIQUE|FULLTEXT|SPATIAL] INDEX index_n... -
CREATE PROCEDURE
Syntax: CREATE [DEFINER = { user | CURRENT_USER }] PROCEDURE sp_name ([proc_paramet -
CREATE SERVER
Syntax: {{{ CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name... -
CREATE TABLE
Syntax: CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name (create_definition,...) [tab -
CREATE TABLESPACE
Syntax: {{{ CREATE TABLESPACE tablespace_name ADD DATAFILE 'file_name' ... -
CREATE TRIGGER
Syntax: CREATE [DEFINER = { user | CURRENT_USER }] TRIGGER trigger... -
CREATE VIEW
Syntax: {{{ CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | T... -
Virtual Columns4
Syntax <type> [GENERATED ALWAYS] AS ( <expression> ) [VIRTUAL | PERSIS...
