mysql-if example sample eg e.g.

if statment


IF expression THEN commands 
[ELSEIF expression THEN commands] 
[ELSE commands] 
END IF; 


IF quantity_in_stock < 100 THEN 
INSERT INTO infologs(msg) 
VALUES (prd_code); 
END IF; 
FETCH cur_product INTO prd_code; 
UNTIL no_more_products = 1 
END REPEAT; 
CLOSE cur_product; 
SELECT * FROM infologs; 
DROP TABLE infologs; 
END$$ 
DELIMITER;