/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

1 vote123 views1 answer
Sql dcl
SQL
0 vote161 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote173 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote123 views2 answers
Sql join on comma separated field
SQL
14 votes124 views2 answers
How to auto increment in sql
SQL
9 votes164 views3 answers
Postgres make sql dump
SQL
8 votes128 views2 answers
Between operator
SQL
0 vote124 views1 answer
Delete double on SQL with multiple primary keys
SQL
1 vote130 views1 answer
Where not in array sql
SQL
0 vote187 views1 answer
Setting default value for Boolean data type in SQL
SQL