MySQL - Multiple Update on Select

UPDATE table_1 AS t1, table_2 AS t2
SET
t1.column_name1 = t2.column_name1
t1.column_name2 = t2.column_name2
WHERE t1.column_name = t2.column_name

This mysql statement helps me update my records.

No comments:

Post a Comment