SQL QUERY TO DUPLICATE AND UPDATE ROWS THAT COMMIT X REQUIREMENT use hrrt; SELECT * FROM hrrt.wp_mcp_banner_section; CREATE TEMPORARY TABLE if not exists tmptable SELECT * FROM wp_mcp_banner_section WHERE mcp_content_comb_id = 400; UPDATE tmptable SET mcp_content_comb_id = 5 , id = null WHERE mcp_content_comb_id =400 ; INSERT INTO wp_mcp_banner_section SELECT * FROM tmptable WHERE mcp_content_comb_id = 5; /*DROP TABLE tmptable;*/ SELECT * FROM tmptable; SELECT * FROM hrrt.wp_mcp_banner_section; DROP TABLE tmptable;
Comments
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎