mysql在怎么创建表

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
    ...
    constraint_name constraint_type
);

CREATE TABLE students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    age INT,
    gender CHAR(1),
    birth_date DATE,
    email VARCHAR(100)
);

ERROR 1050 (42S01): Table 'students' already exists

DROP TABLE IF EXISTS students;
CREATE TABLE students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    age INT,
    gender CHAR(1),
    birth_date DATE,
    email VARCHAR(100)
);

ERROR 1366 (HY000): Incorrect integer value: 'abc' for column 'age' at row 1

ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'