要解决此错误,您需要将PRIMARY KEY添加到auto_increment字段。现在让我们看看如何发生此错误-
在这里,我们正在创建一个表,它给出了相同的错误-mysql> create table DemoTable
(
StudentId int NOT NULL AUTO_INCREMENT,
StudentName varchar(40),
StudentAge int
);
ERROR 1075 (42000) : Incorrect table definition; there can be only one auto column and it must be defined as a key
要解决以上错误,您需要在PRIMARY KEY中添加AUTO_INCREMENT。让我们首先创建一个表-mysql> create table DemoTable
(
StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
StudentName varchar(40),
StudentAge int
);
使用插入命令在表中插入一些记录-mysql> insert into DemoTable(StudentName,StudentAge) values('Chris Brown',19);
mysql> insert into DemoTable(StudentName,StudentAge) values('David Miller',18);
mysql> insert into DemoTable(StudentName,StudentAge) values('John Doe',20);
使用select语句显示表中的所有记录:mysql> select *from DemoTable;
这将产生以下输出-+-----------+--------------+------------+
| StudentId | StudentName | StudentAge |
+-----------+--------------+------------+
| 1 | Chris Brown | 19 |
| 2 | David Miller | 18 |
| 3 | John Doe | 20 |
+-----------+--------------+------------+
3 rows in set (0.00 sec)