How to safely update data in MySQL

• 06, 06, 2022
•  bullgare
•  Databases
• No Comments.

CREATE TABLE IF NOT EXISTS my_tmp_copy LIKE my;

INSERT INTO my_tmp_copy
SELECT * FROM my;

UPDATE my_tmp_copy SET order_count = 5 WHERE customer_id > 0;

RENAME TABLE my TO my_old, my_tmp_copy TO my;