/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 vote273 views1 answer
Oracle create program if not exists
SQL
1 vote226 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote178 views1 answer
Get last run query sql server
SQL
1 vote253 views1 answer
How to delay stored procedure execution in sql server
SQL
1 vote221 views1 answer
Postgres count string length
SQL
0 vote248 views1 answer
Sql server for loop
SQL
0 vote253 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote224 views1 answer
Mariadb errno 121
SQL
5 votes250 views4 answers
Traduction
SQL
0 vote229 views1 answer
Enable sql server full text indexing
SQL