CANDINHO
CANDINHO

Reputation: 11

I need to insert/update a row on a firebird table

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

Answers (1)

GMB
GMB

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

Related Questions