/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

-1 vote107 views2 answers
Mysql get day of week
SQL
5 votes94 views1 answer
Sql first day of current year
SQL
3 votes100 views1 answer
Postgresql cast
SQL
1 vote104 views1 answer
Tsql create unique index composite
SQL
1 vote107 views1 answer
Access the postgres psql
SQL
2 votes129 views2 answers
Install postgresql
SQL
0 vote116 views1 answer
Remove transient options sql wordpress
SQL
0 vote99 views1 answer
Mysql where don't have string
SQL
0 vote97 views1 answer
Sqlite explain plan
SQL
22 votes124 views4 answers
Mysql date format
SQL