mysql创建 表的过程

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    ...
    columnN datatype,
    [constraint1, constraint2, ...]
);

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

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

ERROR 1067 (42000): Invalid default value for 'age'

ALTER TABLE students MODIFY COLUMN age INT DEFAULT 0;

ERROR 1044 (42000): Access denied for user 'user'@'localhost' to database 'database_name'

GRANT ALL PRIVILEGES ON database_name.* TO 'user'@'localhost';
FLUSH PRIVILEGES;