/SQL/How to use a trigger to validate input data

How to use a trigger to validate input data

-- validate email
CREATE TRIGGER `person_validate_insert`
	BEFORE INSERT
	ON `person`
	FOR EACH ROW
BEGIN
	IF NEW.`email` NOT LIKE '%_@%_.__%' THEN
		SIGNAL SQLSTATE VALUE '45000'
			SET MESSAGE_TEXT = '[table:person] - `email` column is not valid';
	END IF;
END;

Source: falseisnotnull.wordpress.com

Similar codes

0 vote174 views1 answer
Get statis values sql
SQL
4 votes120 views1 answer
Sql group by year
SQL
1 vote124 views1 answer
Show table columns
SQL
0 vote158 views1 answer
When mysql server would not work in xampp
SQL
0 vote124 views1 answer
Sql developer export connections
SQL
2 votes125 views2 answers
How to check database username and password in postgresql
SQL
0 vote138 views1 answer
Drush run sql select
SQL
0 vote142 views1 answer
How to find total working hour in sql
SQL
0 vote161 views1 answer
Insert output identity
SQL
0 vote139 views1 answer
Mysql error 1251
SQL