MySQL建表语句：role_tbl 表结构及自增值设置

DROP TABLE IF EXISTS role_tbl; CREATE TABLE role_tbl ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, code varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, type tinyint(4) NOT NULL, description varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, enabled tinyint(4) NULL DEFAULT 1, updated_at timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP, created_by varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, updated_by varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX uniq_role_tbl(name) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 451 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = COMPACT; 在建表语句中，AUTO_INCREMENT = 451表示设置表中id字段的初始自增值为451。每次向表中插入一条新记录时，id字段的值会根据当前最大值自动增加。在这种情况下，第一条插入的记录的id值将是451，接下来的记录将依次递增。