MySQL support (DDL)

[nene]

DDL Statements

• view
  • CREATE VIEW
    • OR REPLACE
    • ALGORITHM = UNDEFINED | MERGE | TEMPTABLE
    • DEFINER = user
    • SQL SECURITY { DEFINER | INVOKER }
    • column list
    • WITH [CASCADED | LOCAL] CHECK OPTION
  • DROP VIEW
    • IF EXISTS
    • multiple views
    • RESTRICT | CASCADE
  • ALTER VIEW
    • ALGORITHM = UNDEFINED | MERGE | TEMPTABLE
    • DEFINER = user
    • SQL SECURITY { DEFINER | INVOKER }
    • column list
    • WITH [CASCADED | LOCAL] CHECK OPTION
• database
  • CREATE DATABASE
  • DROP DATABASE
  • ALTER DATABASE
• event
  • CREATE EVENT
  • DROP EVENT
  • ALTER EVENT
• function
  • CREATE FUNCTION
  • CREATE PROCEDURE
  • DROP FUNCTION
  • DROP PROCEDURE
  • ALTER FUNCTION
  • ALTER PROCEDURE
• logfile group
  • CREATE LOGFILE GROUP
  • DROP LOGFILE GROUP
  • ALTER LOGFILE GROUP
• server
  • CREATE SERVER
  • DROP SERVER
  • ALTER SERVER
• tablespace
  • CREATE TABLESPACE
  • DROP TABLESPACE
  • ALTER TABLESPACE
• spatial reference system
  • CREATE SPATIAL REFERENCE SYSTEM
  • DROP SPATIAL REFERENCE SYSTEM
• trigger
  • CREATE TRIGGER
  • DROP TRIGGER
• index
  • CREATE INDEX
  • DROP INDEX
• ALTER INSTANCE