drop table if exists sub_category;
CREATE TABLE SUB_CATEGORY (
CATEGORY_CD CHAR(2) NOT NULL,
SUB_CATEGORY_CD CHAR(2) NOT NULL,
SUB_CATEGORY_NAME VARCHAR(20) NOT NULL,
PRIMARY KEY (CATEGORY_CD, SUB_CATEGORY_CD) )
ENGINE= MYISAM CHARACTER SET utf8 ;//问题就在这里
CREATE TABLE SUB_CATEGORY (
CATEGORY_CD CHAR(2) NOT NULL,
SUB_CATEGORY_CD CHAR(2) NOT NULL,
SUB_CATEGORY_NAME VARCHAR(20) NOT NULL,
PRIMARY KEY (CATEGORY_CD, SUB_CATEGORY_CD) )
ENGINE= MYISAM CHARACTER SET utf8 ;//问题就在这里