该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
CREATE TABLE renttable (rerumdate date DEFAULT NULL,
cusrid int(10) NOT NULL,
carsid int(10) NOT NULL,
userid int(10) NOT NULL,
rentflag int(10) DEFAULT NULL,
begindate date DEFAULT NULL,
shouldretumdate date DEFAULT NULL,
rerumdate date DEFAULT NULL,
price double(10,0) NOT NULL,
shouldpayprice double(10,0) NOT NULL,
imprest double(10,0) NOT NULL,
tableid varchar(64) NOT NULL,
id int(10) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id),
KEY userid (userid),
KEY carsid (carsid),
KEY cusrid (cusrid),
CONSTRAINT renttable_ibfk_1 FOREIGN KEY (carsid) REFERENCES cars (id),我在MYSQL数据库中创建表时出现错误,我不太清楚错在哪里,请知道的人指点一下,代码如上,错误提示是ERROR 1064(42000):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 "atline 18