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)
);
真的看不出来哪一行写错了，亲们帮看看呗···

[orochiheart]

哥 这里是sqlserver版

[發糞塗牆]

你直接给出报错信息好点，这边没环境

[Yole]

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)
  );

[ChinaITOldMan]

在mysql的企业管理中建立比较容易