Re: what happens when Auto Increment reaches max value?
Posted by: Peter Brawley
Date: August 26, 2014 12:34PM

> What happens with a field marked as AutoIncrement reaches its maximum value?

It wraps, so make sure you use a big enough int to avoid that.

> If you delete a row, does this allow another row to be added?

No, auto_increment does not back & fill.

> How can you go about freeing up "autoincrement" values to add more rows?

As above, change the type -> mediumint or bigint.

Options: ReplyQuote


Subject
Written By
Posted
Re: what happens when Auto Increment reaches max value?
August 26, 2014 12:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.