SQLCREATE TABLE tb_carousel carousel_id int11 NOT NULL AUTO_INCREMENT COMMENT 首页轮播图主键id carousel_url varchar100 CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT COMMENT 轮播图 redirect_u

将第7行和第9行的(0)去掉即可，正确的语句如下：

CREATE TABLE tb_carousel ( carousel_id int(11) NOT NULL AUTO_INCREMENT COMMENT '首页轮播图主键id', carousel_url varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '轮播图', redirect_url varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''##'' COMMENT '点击后的跳转地址(默认不跳转)', carousel_rank int(11) NOT NULL DEFAULT 0 COMMENT '排序值(字段越大越靠前)', is_deleted tinyint(4) NOT NULL DEFAULT 0 COMMENT '删除标识字段(0-未删除 1-已删除)', create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', create_user int(11) NOT NULL DEFAULT 0 COMMENT '创建者id', update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间', update_user int(11) NULL DEFAULT 0 COMMENT '修改者id', PRIMARY KEY (carousel_id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '轮播图表' ROW_FORMAT = Dynamic