MySQL：＃1075-错误的表格定义；自动增量与另一个键？

您 可以 拥有不是的自动递增列，

PRIMARY KEY

CREATE TABLE members (   id int(11)  UNSIGNED NOT NULL AUTO_INCREMENT,  memberid VARCHAr( 30 ) NOT NULL ,   `time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,   firstname VARCHAr( 50 ) NULL ,   lastname VARCHAr( 50 ) NULL ,   PRIMARY KEY (memberid) ,  KEY (id)    --- or:    UNIQUE KEY (id)) ENGINE = MYISAM;