matheus-santos · October 11, 2018 21:22
diff --git a/duplicate_row_in_mysql.sql b/duplicate_row_in_mysql.sql
 -- Replace `{{TABLE_NAME}}` to desired table
 -- Replace `{{ID}}` to desired row you want to replace
 create temporary table `temp` select * from `{{TABLE_NAME}}` where id = {{ID}};
 update `temp` SET id = (select id from {{TABLE_NAME}} order by id desc limit 1) + 1 where id = {{ID}};
 insert into `{{TABLE_NAME}}` select * from `temp`;
 drop TEMPORARY table if exists `temp`;
	-- Replace `{{TABLE_NAME}}` to desired table
	-- Replace `{{ID}}` to desired row you want to replace
	create temporary table `temp` select * from `{{TABLE_NAME}}` where id = {{ID}};
	update `temp` SET id = (select id from {{TABLE_NAME}} order by id desc limit 1) + 1 where id = {{ID}};
	insert into `{{TABLE_NAME}}` select * from `temp`;
	drop TEMPORARY table if exists `temp`;