Counter property in product id?

Question

MySQL

Hello.
The counter property has disappeared from the product id column.
How to set the counter property and where to find it(?

Answer 1

ALTER TABLE your_table MODIFY COLUMN id INT AUTO_INCREMENT PRIMARY KEY