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;