mysql - SQL语法错误

Question

CREATE TABLE  `users` (

 `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
 `type` ENUM(  `member` ,  `admin` ) NOT NULL ,
 `username` VARCHAR( 30 ) NOT NULL ,
 `email` VARCHAR( 80 ) NOT NULL ,
 `pass` VARBINARY( 32 ) NOT NULL , 
 `first_name` VARCHAR( 20 ) NOT NULL , 
 `last_name` VARCHAR( 40 ) NOT NULL , 
 `date_expires` DATE NOT NULL , 
 `date_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
 `date_modified` TIMESTAMP NOT NULL DEFAULT `0000-00-00 00:00:00` ,
PRIMARY KEY (  `id` ) , 
UNIQUE KEY  `username` (  `username` ) ,
UNIQUE KEY  `email` (  `email` ) 
) ENGINE = MYISAM DEFAULT CHARSET = utf8; 

MySQL 说:

#1064 - 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 'member,admin) NOT NULL, username VARCHAR(30) NOT NULL, email VARCHAR(80)' at line 3

我正在使用的共享服务器使用 4.4。谢谢阅读。本人纯新手，才学php/mysql一个月，请通俗一点讲。

Answer 1

您需要引用 ENUM 值

type ENUM( 'member' , 'admin' ) NOT NULL ,

不要像现在这样反引号

这一行也是一样

`date_modified` TIMESTAMP NOT NULL DEFAULT `0000-00-00 00:00:00`

应该是

`date_modified` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'