How to Remove AUTO_INCREMENT FROM a column?

Databases
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