Problem One:
If I have entered 10 records, and deleted 9th, 10th records. The next auto increment value will be 11, not 9.
Solution:
Run a query: ALTER TABLE tablename AUTO_INCREMENT = 1
- Nov 09 Wed 2011 10:59
-
MYSQL: HOW to reset auto increment number
請先 登入 以發表留言。