How to remove auto increment in MySQL

In this Post we will see how we can remove Auto_increment in MySQL.

To remove the AUTO_INCREMENT in MySQL, we will modify the table with an Alter statement and remove the AUTO_INCREMENT keyword from the column name.

Syntax to remove auto increment in MySQL

Alter table table_name col_nm datatype;

Example to remove auto increment in MySQL

Alter table Access modify id int;

Here Auto_increment will be removed from the id column of the Access table.