/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

2 votes333 views1 answer
Scaffold npgsql net core
SQL
0 vote326 views1 answer
How to put value in parameters in mysqldataadapter
SQL
6 votes353 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes321 views2 answers
Mysql show table column comments sql
SQL
3 votes312 views3 answers
Sql current year
SQL
6 votes300 views1 answer
Oracle trigger after connect
SQL
1 vote342 views1 answer
Date in where on datetime column clause mysql
SQL
3 votes326 views2 answers
Oracle apex charging debug
SQL
0 vote318 views1 answer
Alter table myisam to innodb
SQL
3 votes342 views1 answer
Sql insert inserted id
SQL