DELIMITER $$
 
USE `store`$$
 
DROP TRIGGER /*!50032 IF EXISTS */ `updateStatus`$$
 
CREATE
    /*!50017 DEFINER = 'root'@'localhost' */
    TRIGGER `updateStatus` AFTER UPDATE ON `product` 
    FOR EACH ROW BEGIN
	SELECT stock,CASE WHEN stock = 0 THEN UPDATE product SET STATUS = 0;
    END;
$$
 
DELIMITER ;
 

   SELECT product,stock,IF(stock != 0,'active','inactive') AS STATUS FROM product