<p>I have a problem with MYSQL Workbench. Let's say I have this table and user "x" has an index of 8. Let's say I delete this user so now I only have 7 users. If I create a new user using the Java console, the new user will be created with ID 9 because it is auto-incremented. Is there a way to tell Workbench to start from the last number? In this specific case, create the new user starting from 8 instead of 9? </p> <p>I tried checking everywhere on the web but only found some queries to recreate the table but that's not what I want because I have some foreign keys linked to the table so I can't just drop the table and recreate Create another one. </p>