/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

1 vote211 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
0 vote217 views2 answers
Postgres isnull
SQL
0 vote204 views1 answer
Sql order by except one row
SQL
0 vote259 views1 answer
Sql developer format sql
SQL
5 votes177 views1 answer
Mysql change primary key
SQL
0 vote200 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote157 views1 answer
Query for maximum salary
SQL
15 votes181 views4 answers
Mysql where value is null
SQL
28 votes182 views4 answers
Show tables mysql
SQL
0 vote197 views1 answer
Psql attribute cannot login
SQL