How to Remove AUTO_INCREMENT FROM a column?

Databases
1

Ok, one can remove PRIMARY KEY CONSTRAIN FROM a column with:
ALTER TABLE table_name DROP PRIMARY KEY;

But how do you also remove auto increment from the same column so that the column no longer generates an automatic value upon INSERT?

2

spent 5 min and cannot find the answer, so i think easiest way is to do the following:

  1. add new INT column without AUTO_INCREMENT
  2. copy column value
  3. drop AUTO_INCREMENT column
3

you can alter the column and just redefine it without the auto_increment tag:

ALTER TABLE mytable CHANGE my_col my_col INT(10) UNSIGNED NOT NULL

Harder to make it dynamic though