在mysql中如何创建表

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

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) UNIQUE
);

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

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

ERROR 1265 (01000): Data truncated for column 'age' at row 1

INSERT INTO students (name, age, gender, birth_date, email) VALUES ('Alice', 25, 'F', '1996-05-12', 'alice@example.com');

ERROR 1062 (23000): Duplicate entry 'alice@example.com' for key 'email'

INSERT INTO students (name, age, gender, birth_date, email) VALUES ('Bob', 22, 'M', '1999-07-20', 'bob@example.com');