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
这是什么错误，如何解决？请大家帮我看看，不胜感激。
