c 创建mysql表代码

CREATE TABLE IF NOT EXISTS `students` (
    `id` INT UNSIGNED AUTO_INCREMENT,
    `name` VARCHAR(50) NOT NULL,
    `age` INT NOT NULL,
    `gender` ENUM('male', 'female') NOT NULL,
    `class` VARCHAR(50),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

DROP TABLE IF EXISTS `students`;
CREATE TABLE `students` (
    ...
);

ERROR 1366 (HY000): Incorrect string value: '\\xE5\\x9B\\x9B\\xE8\\x8F\\x9C' for column 'name' at row 1

ALTER TABLE `students` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

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

ALTER TABLE `students` ADD UNIQUE INDEX `idx_unique_id` (`id`);