Re: JOIN BETWEEN 2 TABLES WITH DIFFERENT ID COUNTING

[Rick James]

Bad design. Don't expect two AUTO_INCREMENTs to stay in sync.

If you want one id to match another, then don't make it AUTO_INCREMENT. Instead copy the value in. Such as

$id = SELECT id FROM table1 WHERE name = $name;
INSERT INTO table2 (id, ...) VALUES ($id, ...);