MySQL版本5.5.25
创建数据库表的代码:
DROP TABLE IF EXISTS nb_article
;
CREATE TABLE nb_article
(id
bigint(20) NOT NULL,appreciable
tinyint(1) NOT NULL DEFAULT 0,approve_cnt
int(11) NOT NULL,author_id
bigint(20) DEFAULT NULL,cate_id
bigint(20) NOT NULL,commented
tinyint(1) NOT NULL DEFAULT 0,content
mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,cover
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,draft
tinyint(1) NOT NULL DEFAULT 1,md_content
mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci,modify
datetime(6) DEFAULT NULL,post
datetime(6) NOT NULL,summary
varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,text_content
mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci,title
varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,top
int(11) DEFAULT NULL,url_seq
varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,view
int(11) NOT NULL,cate_refer_id
bigint(20) DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE,
INDEX FKm9lpoad6mhygm6ybseq2kkg30
(cate_refer_id
) USING BTREE,
CONSTRAINT FKm9lpoad6mhygm6ybseq2kkg30
FOREIGN KEY (cate_refer_id
) REFERENCES nb_cate
(id
) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
运行时的错误:
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) DEFAULT NULL,post
datetime(6) NOT NULL,summary
varchar(300) CHAR' at line 12
datetime 类型不需要制定数据大小,把大小去掉就可以了
modify 是关键字,不能直接当字段名,你改一下,比如
modifyDatetime