CREATE TABLE

CREATE TABLE table_name_01(
    column_name_01 type AUTO_INCREMENT NOT NULL,
    column_name_02 type NOT NULL,
    column_name_03 type,
    PRIMARY KEY (column_name_01)
)
;

CREATE TABLE FROM ANOTHER TABLE

CREATE TABLE table_name_01 AS
SELECT
    *
FROM
    table_name_02
;

CREATE DATABASE

CREATE DATABASE IF NOT EXISTS database_name_01
;