[mysql] 날짜순으로 primary key 재 등록

ALTER TABLE tb_error ADD COLUMN id INT NOT NULL;
SET @x = 0;
UPDATE tb_error SET id = (@x:=@x+1) ORDER BY create_dt ASC;
ALTER TABLE tb_error ADD PRIMARY KEY id (id);
ALTER TABLE tb_error CHANGE id id INT NOT NULL AUTO_INCREMENT;