/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 vote109 views1 answer
Partial search in sql
SQL
0 vote123 views1 answer
Redshift running queries
SQL
0 vote112 views2 answers
Return the number of records in a single table mysql
SQL
0 vote103 views1 answer
Oracle search columns in schema
SQL
0 vote114 views1 answer
Repeatable read trong sql server
SQL
0 vote119 views1 answer
Mysql delete from where like
SQL
0 vote133 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote102 views1 answer
Initcap in sql
SQL
1 vote116 views1 answer
Oracle create as select
SQL
-1 vote124 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL