/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 vote250 views1 answer
Mysql best varchar length size
SQL
0 vote250 views1 answer
How to find columns with null values in sql
SQL
0 vote226 views1 answer
Opensuse stop MySQL
SQL
5 votes241 views1 answer
Find table from column name in sql
SQL
16 votes264 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote240 views2 answers
Get top 1 row of each group
SQL
0 vote226 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
10 votes277 views6 answers
Mysql set root password
SQL
28 votes218 views4 answers
Mysql delete database
SQL
0 vote224 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL