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.