/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

8 votes187 views1 answer
Mysql restore database
SQL
1 vote173 views1 answer
Sql drop with dependencies
SQL
0 vote178 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote185 views1 answer
Mysql order by where condition sub query
SQL
0 vote181 views1 answer
T sql less than date
SQL
0 vote184 views1 answer
Difference between min and max date sql
SQL
0 vote191 views1 answer
Login failed for user sql server
SQL
51 votes297 views6 answers
Opera gx
SQL
2 votes164 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
1 vote184 views1 answer
Sql server 2012 query history
SQL