SQL- SQL query to increase or decrease price in the table.

QuestionsCategory: MySQLSQL- SQL query to increase or decrease price in the table.
Sandeep asked 1 month ago

SQL query to increase or decrease price in the table. I want to increase or decrease the existing price..

1 Answers
matrix Staff answered 4 weeks ago
UPDATE `product` SET `price` = `price` + ROUND(`price` * (0.1), 0) WHERE `product_id` =1

Please Check the link
https://www.stackofcodes.in/2019/06/23/how-to-increase-or-decrease-the-price-of-all-products-in-the-table-using-sql/