/SQL/Trigger stock phpmyadmin output message

Trigger stock phpmyadmin output message

DELIMITER $$

CREATE TRIGGER testa_trig  
BEFORE INSERT ON testa 
FOR EACH ROW BEGIN
    IF (NEW.c > 100) THEN 
        SIGNAL SQLSTATE '02000' SET MESSAGE_TEXT = 'Warning: c > 100!';
    END IF;
END$$

DELIMITER ;

Source: stackoverflow.com

Similar codes

0 vote303 views1 answer
Get sum sqlite android
SQL
2 votes314 views1 answer
Mysql increment value by 1 in update
SQL
0 vote311 views1 answer
Mysql 5.7 in centos 7
SQL
2 votes249 views1 answer
Sql select in list
SQL
4 votes256 views1 answer
Install postgres 12 on ubuntu
SQL
0 vote288 views1 answer
Difference between 2 query results sql server
SQL
0 vote288 views1 answer
Initcap in sql
SQL
10 votes326 views5 answers
Create table mysql query
SQL
1 vote288 views1 answer
Alter table column size oracle
SQL
0 vote272 views1 answer
Drop check command
SQL