有2張TABLE:A、B
要由B表的資料更新至A表,MYSQL的寫法為:
1 2 3 |
UPDATE A INNER JOIN A ON A.id = B.id SET A.column = B.column |
有2張TABLE:A、B
要由B表的資料更新至A表,MYSQL的寫法為:
1 2 3 |
UPDATE A INNER JOIN A ON A.id = B.id SET A.column = B.column |