MYSQL 행복제..귀찮...

https://stackoverflow.com/questions/11331573/mysql-copy-row-but-with-new-id/11331672

템포 테이블만들고, 키삭제하고 그걸다시 넣고, 다시 삭제하고...귀찮..

CREATE TEMPORARY TABLE tmp SELECT * from my_table WHERE ...;
ALTER TABLE tmp drop pk_id; # drop autoincrement field
# UPDATE tmp SET ...; # just needed to change other unique keys
INSERT INTO my_table SELECT 0,tmp.* FROM tmp;
DROP TEMPORARY TABLE tmp;