Cacher is the code snippet organizer for pro developers

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