/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

21 votes222 views3 answers
Sql server search column name in all tables
SQL
-1 vote244 views1 answer
Difference berween database and data base management system
SQL
0 vote207 views1 answer
Firebird where
SQL
0 vote209 views1 answer
PGSQL dynamic table name
SQL
57 votes316 views6 answers
Sql alter table
SQL
6 votes204 views4 answers
Mysql group by month
SQL
2 votes211 views2 answers
Enable foreign key checks postgres
SQL
0 vote181 views1 answer
How to fetch highest score in minimum time using mysql
SQL
2 votes201 views1 answer
Mysql virtual column
SQL
1 vote226 views1 answer
Mysql count all table rows
SQL