Relative Content

Tag Archive for sql

SQL: multiply values for each rows for column “price”

I have a Prestashop website where I need to increase price for each products and specifically in table “products” I need to multiply column “price” (for each rows that contain already values) for 1.22 (I need to add Italian VAT on this way).

Replace default delivery date with Its actual delivery date

There is a table with Order ID, Delivery Date, Delivery Sequence Number, and Record Update Date & Time. When a product is in the warehouse, the default delivery date is set to 1999-12-31, indicating that the product is not ready for delivery. When the product is scheduled for delivery, the record displays the actual delivery date. If the record is modified, a new row is inserted with a new sequence number, along with the updated record’s modification date and time.