Re: Reseting Tables within the Database

[Shantanu Oak]

Drop the column from the table. Then put it back. MySQL will renumber the values in the column in unbroken sequence.

ALTER TABLE tbl_name DROP myid;

ALTER TABLE tbl_name ADD COLUMN myid INT AUTO_INCREMENT NOT NULL PRIMARY KEY;