Mysql update query with select with join - Stack Overflow

You can't have SET (a,b) = (value_a, value_b) in MySQL. Rewrite the query. Something like this: UPDATE keywords_stats_google_temp AS u JOIN ...

stackoverflow.com