/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 vote352 views1 answer
Month mysql
SQL
0 vote450 views1 answer
Plpgsql create function
SQL
1 vote320 views1 answer
Unique vs distinct sql
SQL
0 vote357 views1 answer
Show size of all tables postgres
SQL
0 vote400 views10 answers
Sql statement checker corrector
SQL
1 vote349 views1 answer
Mysql random limit 1
SQL
1 vote365 views1 answer
How to get mysql db size
SQL
0 vote371 views1 answer
Not equal to blank in mysql
SQL
1 vote373 views3 answers
How to update column name in psql
SQL
2 votes352 views2 answers
How to get capital letter first in sql
SQL