/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

9 votes209 views3 answers
Date format in sql
SQL
3 votes183 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote186 views1 answer
Mysql filter based on datediff
SQL
0 vote178 views1 answer
Pgadmin see indexes
SQL
0 vote189 views1 answer
Groupby error in mysql
SQL
11 votes181 views2 answers
Insert current date sql
SQL
3 votes259 views1 answer
Oracle cannot access v$session
SQL
0 vote174 views1 answer
Mysql into outfile with headers
SQL
1 vote190 views3 answers
Drop unique key constraint in sql server
SQL
0 vote180 views1 answer
Create database store
SQL