A MySQL trigger example-update another field in the same table while the state changes

#表 ( jc_shop_product ) has a status value-whether the shelves (On_sale) to shelves (0) into the shelf (1) and set the shelf time (on_sale_time)

Drop trigger if exists update_on_sale_time_of_product;delimiter//CREATE trigger Update_on_sale_time_of_product BEFOR E UPDATE on jc_shop_product for each ROW to BEGIN IF old.on_sale=0 && new.on_sale=1 then SET New.on_sa Le_time=now ();     END IF; end;//delimiter;

A MySQL trigger example-update another field in the same table while the state changes