MySQL的语法错误,帮忙找找

CREATE tabel WROX_USER(
USER_ID int unsigned NOT NULL AUTO_INCREMENT ,
USERNAME varchar( 20 ) NOT NULL ,
PASSWORD char( 40 ) NOT NULL ,
EMAIL_ADDR varchar( 100 ) NOT NULL ,
IS_ACTIVE TINYINT( 1 ) DEFAULT 0,
PRIMARY KEY ( USER_ID )
) ENGINE = MYISAM DEFAULT CHARACTER SET latin1 COLLATE latin1_eneral_cs AUTO_INCREMENT =0;

作者: nickwill1984   发布时间: 2011-06-06

PASSWORD 是 mysql 保留字,一定要用时需转义

CREATE tabel WROX_USER(
USER_ID int unsigned NOT NULL AUTO_INCREMENT ,
USERNAME varchar( 20 ) NOT NULL ,
`PASSWORD` char( 40 ) NOT NULL ,
EMAIL_ADDR varchar( 100 ) NOT NULL ,
IS_ACTIVE TINYINT( 1 ) DEFAULT 0,
PRIMARY KEY ( USER_ID )
) ENGINE = MYISAM DEFAULT CHARACTER SET latin1 COLLATE latin1_eneral_cs AUTO_INCREMENT =0; 
 

作者: xuzuning   发布时间: 2011-06-06