/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 vote160 views1 answer
Mysql conf.d exampel
SQL
15 votes308 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote225 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote145 views1 answer
One table with another
SQL
18 votes136 views3 answers
Find column name in database
SQL
0 vote150 views1 answer
Create dump file mysql workbench
SQL
3 votes167 views1 answer
How to add unique constraint in mysql table
SQL
0 vote162 views1 answer
Mysql config slave
SQL
0 vote176 views5 answers
How to make trigger in phpmyadmin
SQL
4 votes139 views1 answer
Oracle delete last row
SQL