/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

2 votes367 views1 answer
Tsql copy table
SQL
23 votes367 views1 answer
How remove column in mysql
SQL
2 votes376 views1 answer
How to delete columns in sql
SQL
0 vote374 views2 answers
Call to undefined function mysql_query()
SQL
6 votes396 views2 answers
Mysql convert timestamp to date
SQL
0 vote459 views1 answer
Mysql get nested records
SQL
0 vote368 views1 answer
Sql get date from timestamp
SQL
0 vote330 views1 answer
Count column of tables psql
SQL
0 vote345 views1 answer
Select last 2 characters sql
SQL
4 votes342 views1 answer
Postgresql show current database
SQL