View Single Post
  #2  
Old 08-07-2024, 12:00 PM
nilbog
Hill Giant
 
Join Date: Nov 2007
Posts: 198
Default

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:

Code:
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
__________________
https://www.project1999.com
Reply With Quote