/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 votes151 views4 answers
Check timezone of mysql database
SQL
0 vote186 views1 answer
Isnull in sqlite
SQL
0 vote156 views1 answer
Incorrect string value: mysql
SQL
0 vote185 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote164 views1 answer
How to install Firebird
SQL
1 vote149 views1 answer
Sql delete all values in a column
SQL
0 vote149 views1 answer
Sql query for getting data with join and count
SQL
0 vote159 views1 answer
How to select a row in sql
SQL
0 vote158 views3 answers
Query string not ending with with vowels
SQL
4 votes151 views2 answers
Oracle unlock user
SQL