大家帮忙看一下这是什么错误?谢谢了。
我创建表时用以下语句:
Create table CDRentLog(
CDRL_ID int primary key auto_increment not null,
CDRL_USERID varchar(8) not null,
CDRL_CDID varchar(8) not null,
CDRL_BORROWDATE DATETIME not null,
CDRL_RETURNDATE DATETIME,
CDRL_STATUS varchar(6) ENUM(‘FINISH’,’ON’,’OFF’),
CDRL_DAYS int,
CDRL_INCOME DECIMAL(9,2));
但是提示有错误:
ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'ENUM(‘FINISH’,’ON’,’OFF’),
CDRL_DAYS int,
CDRL_INCOME DECIMAL(9,2))' at line 7
这是什么错误,如何解决?请大家帮我看看,不胜感激。