pwqmzxdy

1
2SQL QUERY TO DUPLICATE AND UPDATE ROWS THAT COMMIT X REQUIREMENT
3use hrrt;
4SELECT * FROM hrrt.wp_mcp_banner_section;
5CREATE TEMPORARY TABLE if not exists tmptable 
6SELECT * FROM wp_mcp_banner_section WHERE mcp_content_comb_id = 400;
7UPDATE tmptable SET mcp_content_comb_id = 5 , id = null WHERE mcp_content_comb_id =400 ;
8INSERT INTO wp_mcp_banner_section SELECT * FROM tmptable WHERE mcp_content_comb_id = 5;
9 /*DROP TABLE tmptable;*/
10 SELECT * FROM tmptable;
11SELECT * FROM hrrt.wp_mcp_banner_section;
12DROP TABLE tmptable;