以下sql语句报错:Unknown collation uutf8mb4_general_ci 怎么修改DROP TABLE IF EXISTS goods;CREATE TABLE goods Gid int0 NOT NULL AUTO_INCREMENT Sid int0 NULL DEFAULT NULL Gname varchar255 CHARACTER SET utf8m
请将 uutf8mb4_general_ci 修改为 utf8mb4_general_ci。修改后的语句如下:
DROP TABLE IF EXISTS goods;
CREATE TABLE goods (
Gid int(0) NOT NULL AUTO_INCREMENT,
Sid int(0) NULL DEFAULT NULL,
Gname varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
Gbuyprice varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
Gsellprice varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
Gphoto varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
Gdescribe varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
Gaudit enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0',
Gstatus enum('0','1','2','3') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0',
Gtime timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
Gupdate_time timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
SELLusername varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
PRIMARY KEY (Gid) USING BTREE,
INDEX Sid(Sid) USING BTREE,
CONSTRAINT Sid FOREIGN KEY (Sid) REFERENCES student (Sid) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic
原文地址: https://www.cveoy.top/t/topic/htFG 著作权归作者所有。请勿转载和采集!