/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 vote165 views1 answer
Alphabetical order mysql
SQL
21 votes176 views1 answer
Cheatsheet for sql
SQL
17 votes172 views3 answers
Postgresql version command
SQL
3 votes177 views1 answer
How to check schema privileges in oracle
SQL
2 votes206 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
-1 vote194 views1 answer
How to Activate the database
SQL
0 vote176 views1 answer
QCompleter con sql
SQL
4 votes169 views1 answer
Psql get sequences
SQL
0 vote167 views2 answers
Sql searching via key word
SQL
0 vote210 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL