/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

18 votes121 views3 answers
Mysql query add column with default string value
SQL
0 vote123 views1 answer
List mysql tables and views
SQL
2 votes81 views1 answer
Sql select in list
SQL
24 votes127 views4 answers
How to add column sql
SQL
0 vote136 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
1 vote170 views1 answer
Insert many to many sql
SQL
0 vote136 views2 answers
Sql query in dax power bi
SQL
1 vote129 views1 answer
Sql where last 12 months
SQL
1 vote129 views1 answer
How to install mysql 8.0 windows service
SQL
4 votes129 views1 answer
Mysql copy table with new name
SQL