mysql - MySQL检查手册语法错误

Question

 CREATE TABLE info(id KEY AUTO_INCREMENT, email VARCHAR(20), name VARCHAR(20));

使用此代码时，在 Ubuntu 终端中，我收到如下错误

ERROR 1064 (42000): 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 'KEY AUTO_INCREMENT, email VARCHAR(20), name VARCHAR(20))' at line 1

请帮助我解决这个问题。感谢提前回复

Answer 1

试试这个:

CREATE TABLE info(
    id int not null AUTO_INCREMENT, 
    email VARCHAR(20), 
    name VARCHAR(20),
    primary key(id)
);