mysql - How to join two tables in an UPDATE statement ...

2012年3月31日 - user_id name tweet_id user_id tweet spam ... You're on the right track, but you need to specify a JOIN between the tables: UPDATE tweets JOIN ...

stackoverflow.com