In above statement, <value> is greater than the current maximum value of the auto-increment column otherwise alter statement will not work. In other words, while resetting the auto increment value yo ...

Hello reader's! if you already using the mysql then you have seen the id with autoincrement always add up. forevery new entery the id will increase even if you drop the table.so if you want to reset ...

Change auto-increment value Changing an auto-increment value is useful when you don't want a gap in an AUTO_INCREMENT column after a massive deletion. For example, you got a lot of unwanted ...

Does the payoff you'd get from doing this outweigh having gaps?<BR><BR>If you're using an auto-increment primary key, I'd imagine that it's not worth the effort.