CREATE TABLE s_dept
(id INT(7)
CONSTRAINT s_dept_id_nn NOT NULL,
name CHAR(25)
CONSTRAINT s_dept_name_nn NOT NULL,
region_id INT(7),
CONSTRAINT s_dept_id_pk PRIMARY KEY (id),
CONSTRAINT s_dept_name_region_id_uk UNIQUE (name, region_id));
报这个语法错误:
'CONSTRAINT s_dept_id NOT NULL,
name CHAR(25)
CONSTRAIN' at line 3
为什么?把CONSTRAINT s_dept_id_nn 和 CONSTRAINT s_dept_name_nn 同时去掉,就OK了,WHY?