What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table ?

It stops incrementing.

It does not overflow to 0 to prevent datalosses, but further inserts are going to produce an error, since thekey has been used already.