mysql自己増加idの並べ替え

368 ワード

ALTER TABLE member DROP COLUMN id;
ALTER TABLE member ADD id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST;
    
        ALTER TABLE member DROP COLUMN id;
    

    
        ALTER TABLE member ADD id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST;