mysql创建表时提示报错

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    ...
);

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100) UNIQUE
);

SHOW GRANTS FOR 'username'@'host';

GRANT CREATE ON database_name.* TO 'username'@'host';

SHOW TABLES LIKE 'table_name';

DROP TABLE table_name;

CREATE TABLE IF NOT EXISTS table_name (
    column1 datatype,
    column2 datatype,
    ...
);

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    ...
) ENGINE=InnoDB;

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    ...
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

df -h

CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100) UNIQUE
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;