2
Which update would use to change one value by the other in a table.
A update on the table produtos spine cod_produto.
I would like a query where in the call table produtos all contained in the column cod_produto the value 000001 are modified in the same column cod_produto for 000002.
I believe that by making a select in the products table and within what goes through it can insert the update query , so you have an id of the line to perform.... See if it helps....
– Augusto Furlan
Take a look at [tour]. You can accept an answer if it solved your problem. You can vote on every post on the site as well. Did any help you more? You need something to be improved?
– Maniero