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;
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;
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