Update with join MYSQL

Question

Update with join MYSQL

Navigation

#1 by (2 votes)

2

I have a table with client data, with the fields 'name_name' and 'code_name'. I need to update the 'codcorretor' from the data of my user table, where I have 'name' and 'codusuario'. So that something like codcorretor=codusuario where nomecorretor=nome

I tried to do this but it did not roll:

update clientes set cli.codcorretor=us.codusuario
inner join usuario us on cli.nomecorretor=us.nome
where us.codusuario in (select codusuario from usuario);

Can anyone help me?

Thank you.

mysql

asked by anonymous 23.11.2015 / 12:37

1 answer

What is the purpose of Int32Rect variables Handling a number of non-mandatory parameters on a route

score 2 · Accepted Answer

In% s with UPDATE , JOIN s must come before JOIN . So your query would look like this:

update clientes
inner join usuario us on cli.nomecorretor = us.nome
set cli.codcorretor = us.codusuario
where us.codusuario in (select codusuario from usuario);