UPDATE multiple tables in MySQL using LEFT JOIN - Stack Overflow

UPDATE multiple tables in MySQL using LEFT JOIN - Stack Overflow

瀏覽:820
日期:2024-04-25
I have two tables, and want to update fields in T1 for all rows in a LEFT JOIN. For an easy example, update all rows of the following result-set: SELECT T1.* FROM T1 LEFT JOIN T2 ON T1.id = T2.id WHERE T2.id IS NULL The MySQL manual states that: ......看更多