Mysql中创建一个表
CREATE TABLE COST(
ID int(4) CONSTRAINT COST PRIMARY KEY,
NAME VARCHAR(50) NOT NULL,
BASE_DURATION int(11),
BASE_COST double(7,2),
UNIT_COST double(7,4),
STATUS CHAR(1) CONSTRAINT COST_STATUS_CK
CHECK (STATUS IN (0,1)),
DESCR VARCHAR(100),
CREATIME DATE DEFAULT SYSDATE ,
STARTIME DATE,
COST_TYPE CHAR(1)
);
真的看不出来哪一行写错了,亲们帮看看呗···
[解决办法]
CREATE TABLE COST(
ID int(4) CONSTRAINT COST PRIMARY KEY,
NAME VARCHAR(50) NOT NULL,
BASE_DURATION int(11),
BASE_COST double(7,2),
UNIT_COST double(7,4),
STATUS CHAR(1) CONSTRAINT COST_STATUS_CK
CHECK (STATUS IN (0,1)),
DESCR VARCHAR(100),
CREATIME DATE DEFAULT SYSDATE ,--CREATIME DATE DEFAULT 'SYSDATE'默认约束默认值没加单引号
STARTIME DATE,
COST_TYPE CHAR(1)
);