Journey
Its all about exploring unexplored paths!
Tuesday, January 25, 2011
MySQL - Restart - AutoInc resets to zero
I noticed fact recently that MySQL Table autoincrement Id value resets to zero, if table is empty.
solution to this is, you can reset the counter to
mysql> ALTER TABLE tbl AUTO_INCREMENT = 1000;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment