MySQL create

create语法可以创建很多对象,比如database,event,table等

1.CREATE DATABASE Syntax
创建数据库

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
    [create_specification] ...

create_specification:
    [DEFAULT] CHARACTER SET [=] charset_name
  | [DEFAULT] COLLATE [=] collation_name
  | DEFAULT ENCRYPTION [=] {'Y' | 'N'}

2.CREATE EVENT Syntax
创建事件

CREATE
    [DEFINER = user]
    EVENT
    [IF NOT EXISTS]
    event_name
    ON SCHEDULE schedule
    [ON COMPLETION [NOT] PRESERVE]
    [ENABLE | DISABLE | DISABLE ON SLAVE]
    [COMMENT 'string']
    DO event_body;

schedule:
    AT timestamp [+ INTERVAL interval] ...
  | EVERY interval
    [STARTS timestamp [+ INTERVAL interval] ...]
    [ENDS timestamp [+ INTERVAL interval] ...]

interval:
    quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |
              WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |
              DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}

CREATE EVENT e_totals
    ON SCHEDULE AT '2006-02-10 23:59:00'
    DO INSERT INTO test.totals VALUES (NOW());

3.CREATE FUNCTION Syntax

4.CREATE INDEX Syntax
创建索引

5.CREATE LOGFILE GROUP Syntax
创建日志

6.CREATE PROCEDURE and CREATE FUNCTION Syntax

7.CREATE SERVER Syntax

8.CREATE SPATIAL REFERENCE SYSTEM Syntax

9.CREATE TABLE Syntax
创建表
https://dev.mysql.com/doc/refman/8.0/en/create-table.html

10.CREATE TABLESPACE Syntax

11.CREATE TRIGGER Syntax
创建触发器

mysql> CREATE TABLE account (acct_num INT, amount DECIMAL(10,2));
Query OK, 0 rows affected (0.03 sec)

mysql> CREATE TRIGGER ins_sum BEFORE INSERT ON account
       FOR EACH ROW SET @sum = @sum + NEW.amount;
Query OK, 0 rows affected (0.01 sec)

mysql> SET @sum = 0;
mysql> INSERT INTO account VALUES(137,14.98),(141,1937.50),(97,-100.00);
mysql> SELECT @sum AS 'Total amount inserted';

每次插入数据,将amount数值加给@sum

12.CREATE VIEW Syntax

参考:
https://dev.mysql.com/doc/refman/8.0/en/sql-syntax-data-definition.html