/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

0 vote298 views1 answer
Site:av.ru "files"
SQL
2 votes240 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote281 views2 answers
Compound operator in sql
SQL
0 vote278 views1 answer
Trigger stock phpmyadmin
SQL
8 votes257 views2 answers
Alert table name mysql
SQL
11 votes262 views2 answers
Oracle source code
SQL
0 vote243 views1 answer
Vbscript create ADODB.Connection
SQL
2 votes289 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote236 views1 answer
How to install Firebird
SQL
2 votes260 views1 answer
Add default sql server
SQL