Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
set auotincrement to 0
- Thread starter theogary
- Start date
sleipnir214
Programmer
Setting the auto_increment counter will not give you that.
In fact, if you reset the counter to a small number and you add a record that would have an auto_increment column value that matches an existing column value, you'll get "duplicate index" error on inserts.
Want the best answers? Ask the best questions!
TANSTAAFL!!
In fact, if you reset the counter to a small number and you add a record that would have an auto_increment column value that matches an existing column value, you'll get "duplicate index" error on inserts.
Want the best answers? Ask the best questions!
TANSTAAFL!!
- Status