I have an update script:
update product set price_sell = 123.45 where code=45
the problem is that I need to create a script with price_sell diferent when I am in a determined table, for example:
update product set price_sell = case database='viadiesel' then 123.45 else 187.74 end if where code=45
how can I do that? Is it possible?