How to do an update in two tables, Ex: first table users
, would only update in senha
, but in table users_info
would update cos fields, cidade
, nascimento
, sexo
e etc.
I can do it in one, but I wanted to do it in two in one operation, I read about INNER JOIN
, but I did not understand it very well for update
UPDATE ?? SET ?? = ? WHERE ?? = ?