The Same record now points to multiple different project queues) show create table project_queues (Which damaged my references in the audit table. When the records are processed, they are deleted.ĭeletion is invoked by rails construction stroy in a loop which triggers DELETE record FROM table on MySql database.īut now I've noticed, that in the table project_queues the autoIncrement Id (primary key) was set up back to 1. I have a database table project_queues which is used as a queue, where I store some records.

Goto the Operations tab and enter 28.I've just run into an issue which I'm not able to solve. Next, locate the highest value for the auto_increment column (say it is id) SELECT MAX(id) maxid FROM mydb.mytable In phpmyadmin, just click the SQL tab, enter the command, and run it.įor a nonempty table, you may want to adjust the auto_increment attribute to the highest existing id in use in case higher entries were deleted.įirst, optimize the table OPTIMIZE TABLE mydb.mytable If you want to hose the data, then be my guest. Since this one of the most frequently asked questions for phpmyadmin, you can learn more about this in this blog : Supplemental Infoįor an empty table, another way to reset the auto_increment attribute is to run TRUNCATE TABLE mydb.tablename ĭon't run this if you have data in it. Click on the Go button for the Table Options box.Enter the new auto_increment starting value.

In the Table Options box find the auto_increment field.

In phpMyAdmin, click on the table you want to reset or change the AUTO_INCREMENT value.

Perhaps you could just select the phpMyAdmin Operations tab:

Reset mysql quot increment