使用sql删除复制数据中的某些数据时，源数据不应丢失。 可能吗？

Question

I have html button in my page. when the button is clicked the copied data of the page will generated. I need to update the one of the value of copied data. If so the original file should not change. Is it possible? to do using sql and php

Answer 1

Try below code also you can change column whatever you want

    CREATE TEMPORARY TABLE tmptable_1 SELECT * FROM table WHERE primarykey = 1;
    UPDATE tmptable_1 SET primarykey = NULL;
    INSERT INTO table SELECT * FROM tmptable_1;
    DROP TEMPORARY TABLE IF EXISTS tmptable_1;