If you are using the auto_increment feature of MySQL and table edits have lead to the value generated being in advance of requirements or just generally adrift you can use the following command to adjust the next auto_increment output value.<\/p>\n\n\n\n
ALTER TABLE <table name> AUTO_INCREMENT = <value><\/pre>\n\n\n\nBear in mind however that it is not possible to put the auto_increment value back to a value less than the current maximum value in the auto_incrementing column so you may need to do some tidying first. You can find the current maximum value using the following command:<\/p>\n\n\n\n
SELECT MAX( <auto incrementing column> ) FROM <table name> ;<\/pre>\n\n\n\nYou can confirm that the change has taken using the following command:<\/p>\n\n\n\n
SHOW TABLE STATUS FROM <DB name> WHERE name LIKE '<table name>' ;<\/pre>\n\n\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"
If you are using the auto_increment feature of MySQL and table edits have lead to the value generated being in advance of requirements or just generally adrift you can use the following command to adjust the next auto_increment output value. ALTER TABLE <table name> AUTO_INCREMENT = <value> Bear in mind however that it is not … <\/p>\n