SQL Query to copy items

[nilbog]

One approach for a single query would be to utilize a temporary table.

Use this at your own discretion and create a backup to ensure nothing bad happens. If you already have a table named temp_table, choose a new naming schema.

For one item at a time and a bit more manual control:

create temporary table temp_table 
as 
select * from items where id = '1377';
update temp_table set id = '90525' where id = '1377';
insert into items select * from temp_table;
drop temporary table temp_table;

-creates temp table
-inserts a new row in temp table of the specified item from items
-updates the id of the item in the temp table
-inserts the edited row into items table
-drops the temp table