I have a regular table with some pricing data. (selling price)
I am to use update query to add 10% to the selling price. I do not know the proper santax to do that. Can someone please help?!? :wink:
I have a regular table with some pricing data. (selling price)
I am to use update query to add 10% to the selling price. I do not know the proper santax to do that. Can someone please help?!? :wink:
How about this?
update table_name set price=price*1.1
I didn't test it.![]()