/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 vote122 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
1 vote107 views1 answer
Delete triger pl pg sql
SQL
0 vote124 views1 answer
Mysql Error Code: 1005
SQL
0 vote108 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote129 views1 answer
Sqlite trim
SQL
0 vote119 views1 answer
Retornar apenas o ano mysql date
SQL
4 votes107 views1 answer
Oracle show errors compilation
SQL
5 votes106 views1 answer
Oracle get nls settings
SQL
0 vote114 views1 answer
Sql track modification
SQL
0 vote133 views2 answers
Sql stored procedure for access frontend
SQL