win7系统中运行MYSQL 这个语句怎么老是错误啊
CREATE TABLE staff
(rank ENUM('employee','manager','contractor') NOT NULL, POSITION VARCHAR(100),
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY(rank,id));
提示: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 '(id))' at line 3