I've got table with following schema:
CREATE TABLE `tblsomething` ( `something_id` int(11) NOT NULL AUTO_INCREMENT, … PRIMARY KEY (`something_id`) ) ENGINE=InnoDB AUTO_INCREMENT=144620955
I need to drop the auto increment. So I'm thinking to do:
ALTER TABLE tblsomething MODIFY something_id int NOT NULL;
But this part of MySQL doc worries me:
In most cases, ALTER TABLE works by making a temporary copy of the original table. The alteration is performed on the copy, and then the original table is deleted and the new one is renamed. While ALTER TABLE is executing, the original table is readable by other sessions. Updates and writes to the table are stalled until the new table is ready, and then are automatically redirected to the new table without any failed updates.
So is dropping auto increment actually one of these cases? Will it lock up my table?