Reputation: 11
I need to update a single row on a table
table name = TB_EST_PRODUTO
row COD_BENEF
I need to insert the code 'PR810000'
where on TB_EST_PRODUTO CST = 040
but I have no idea how to do it
Upvotes: 0
Views: 93
Reputation: 222482
Are you looking for... a simple UPDATE
query, like so?
UPDATE TB_EST_PRODUTO SET COD_BENEF = 'PR810000' WHERE TB_EST_PRODUTO CST = 040
Upvotes: 1