/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 vote379 views3 answers
Epoch to datetime
SQL
0 vote349 views1 answer
Sqlalchemy query sql compiled
SQL
20 votes353 views3 answers
How to open postgresql in mac
SQL
19 votes346 views6 answers
Sql drop table if exists
SQL
1 vote328 views1 answer
Create procedure with encryption
SQL
15 votes361 views4 answers
Mysql export database command line
SQL
2 votes301 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
8 votes317 views1 answer
Oracle find text in functions
SQL
0 vote333 views1 answer
Oracle procedure teamplate
SQL
0 vote397 views1 answer
Get initial in sql
SQL