Re: Reseting Auto Increment for Indexes?

[Sébastien F.]

You should use FOREIGN KEY with CASCADE capabilities:

CREATE TABLE parents (
    id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    ...
);

CREATE TABLE children (
    id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    ...
    parent_id BIGINT UNSIGNED,
    CONSTRAINT FOREIGN KEY (parent_id) REFERENCES parents (id) ON UPDATE CASCADE ON DELETE RESTRICT
)

So, when you update parents.id, children.parent_id will be updated automatically.

Then you can do following to specify next parents.id:

ALTER TABLE parents AUTO_INCREMENT = {{ NEXT_ID }}