/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

13 votes114 views2 answers
Sqlite rename table
SQL
0 vote100 views1 answer
Mysql change default collation
SQL
0 vote106 views1 answer
Get current date data in mysql
SQL
0 vote116 views1 answer
Sql server beginning of month
SQL
0 vote117 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote101 views1 answer
Alter table fulltext
SQL
1 vote150 views1 answer
Oracle transaction rollback not working
SQL
1 vote109 views1 answer
Tsql create unique index composite
SQL
0 vote104 views1 answer
Hive batch drop table
SQL
8 votes144 views2 answers
Oracle auto increment primary key
SQL