/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

2 votes377 views5 answers
Install postgresql 10 centos 7
SQL
0 vote371 views1 answer
Mysql locate
SQL
13 votes366 views2 answers
Sql online compiler
SQL
0 vote347 views1 answer
Sql get guid
SQL
4 votes377 views1 answer
Data types in sql
SQL
0 vote332 views1 answer
SQL get max per id
SQL
0 vote332 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote345 views1 answer
Postgres concat_ws
SQL
4 votes350 views1 answer
Oracle select first 10 rows
SQL
50 votes433 views6 answers
Install mysql on ubuntu
SQL