题解 | #创建一张新表#

CREATE TABLE
    IF NOT EXISTS user_info_vip (
        id int PRIMARY KEY AUTO_INCREMENT COMMENT '自增ID',
        uid int UNIQUE NOT NULL COMMENT '用户ID',
        nick_name varchar(64) COMMENT '昵称',
        achievement int DEFAULT 0 COMMENT '成就值',
        `level` int COMMENT '用户等级',
        job varchar(32) COMMENT '职业方向',
        register_time datetime DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间'
    ) CHARACTER
SET
    utf8 COLLATE utf8_general_ci;