How to update two tables in one statement in mysql (ok)

https://stackoverflow.com/questions/2044467/how-to-update-two-tables-in-one-statement-in-sql-server-2005

Chưa dùng Alias

Có dùng Alias

UPDATE user T1, user_join T2 SET T1.email = '[e-mail]', T2.email='[e-mail]' WHERE T1.id = T2.user_id AND T2.joinid = 4;