0
I used the following command :
update cliente set telefone = '969843225' where nome = 'João da silva';
Afterward:
select * from cliente;
Did not update the record.
Image of the records:
0No answers
Browser other questions tagged sql-update set
You are not signed in. Login or sign up in order to post.
When you do the
select * from cliente where nome = 'João da silva'returns the correct record?– Laércio Lopes
not just set the changes
– alexoab oab
Rectifying it back Empty
– alexoab oab
So that’s the problem
– Laércio Lopes
but as if in the figure I have given phone 333-5648
– alexoab oab
You are missing the identification column in your table (ID) or customer code. When you put this column you can update by this column and not by name...
– Laércio Lopes
but , as it is a demonstration class the update should act . funny functional in the online udmy here nothing rs
– alexoab oab
If select with Where does not work with its name update will not work either.
– Laércio Lopes
Put the ID and update by the ID, see:http://sqlfiddle.com/#! 9/30636e/1
– Laércio Lopes
thanks truth. I just could not understand the reason . because in the course he makes good here needs the ID
– alexoab oab