CREATE TABLE borrowrce(
borrowRecNumber INT(10) NOT NULL auto_increment,
itemCallNumber VARCHAR(20) NOT NULL DEFAULT '0',
staffIDBorrow VARCHAR(10) NOT NULL DEFAULT '',
staffIDReturn VARCHAR(10) DEFAULT NULL,
borrowerID VARCHAR(10) NOT NULL DEFAULT '0',
borrowerEmail VARCHAR(50) NOT NULL DEFAULT '',
borrowDate DATE NOT NULL DEFAULT '0000-00-00',
dueDate DATE NOT NULL DEFAULT '0000-00-00',
returnDate DATE DEFAULT DEFAULT '0000-00-00',
borrowStatus VARCHAR(10) NOT NULL DEFAULT '0',
PRIMARY KEY (borrowRecNumber),
UNIQUE KEY BorrowRefNumber (borrowRecNumber),
KEY BorrowRefNumber_2 (borrowRecNumber)
);
以上是本人建表的语句,可是不知道哪出错了,跪求高手帮帮忙!!!!
(我用的是mysql数据库)!!!
borrowRecNumber INT(10) NOT NULL auto_increment,
itemCallNumber VARCHAR(20) NOT NULL DEFAULT '0',
staffIDBorrow VARCHAR(10) NOT NULL DEFAULT '',
staffIDReturn VARCHAR(10) DEFAULT NULL,
borrowerID VARCHAR(10) NOT NULL DEFAULT '0',
borrowerEmail VARCHAR(50) NOT NULL DEFAULT '',
borrowDate DATE NOT NULL DEFAULT '0000-00-00',
dueDate DATE NOT NULL DEFAULT '0000-00-00',
returnDate DATE DEFAULT DEFAULT '0000-00-00',
borrowStatus VARCHAR(10) NOT NULL DEFAULT '0',
PRIMARY KEY (borrowRecNumber),
UNIQUE KEY BorrowRefNumber (borrowRecNumber),
KEY BorrowRefNumber_2 (borrowRecNumber)
);
以上是本人建表的语句,可是不知道哪出错了,跪求高手帮帮忙!!!!
(我用的是mysql数据库)!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货