trigger stock phpmyadmin output message

Solutions on MaxInterview for trigger stock phpmyadmin output message by the best coders in the world

showing results for - "trigger stock phpmyadmin output message"
Kevin
22 Jan 2018
1DELIMITER $$
2
3CREATE TRIGGER testa_trig  
4BEFORE INSERT ON testa 
5FOR EACH ROW BEGIN
6    IF (NEW.c > 100) THEN 
7        SIGNAL SQLSTATE '02000' SET MESSAGE_TEXT = 'Warning: c > 100!';
8    END IF;
9END$$
10
11DELIMITER ;