Answers for "update based on if mysql"

update if else mysql

UPDATE prices
SET final_price= CASE
   WHEN currency=1 THEN 0.81*final_price
   ELSE final_price
END

Posted by: Guest on August-10-2021

on update date mysql

ALTER TABLE t1 MODIFY post_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Posted by: Guest on April-26-2021

Code answers related to "update based on if mysql"