How can I update 2 tables while doing inner join MySql ...

2013年5月23日 - The general syntax of what you want is: UPDATE table1 AS t1 JOIN table2 AS t2 ON SET t1.col1 = val1, t1.col2 = val2, t2.col3 = val3 ...

stackoverflow.com