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.
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
No comments:
Post a Comment