How to create a MySql auto-increment field?

Question

MySQL

When creating an auto-increment field in the database, an error occurred.
Query error:
#1075 - Incorrect table definition: only one auto-increment column can exist and it must be defined as a key

Answer 1

You probably already have an auto-increment column, or you create a simple one and don't set it to PRIMARY KEY