MySQL UPDATE SET field equals to SELECT - Stack Overflow

As detailed under UPDATE Syntax, for MySQL you want: UPDATE Table1 T1 JOIN Table2 T2 USING (name) SET T1.email = T2.email WHERE (Some ...

www.google.com.tw