/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 vote207 views1 answer
Delete row mssql
SQL
0 vote242 views1 answer
Mysqldump: error:
SQL
0 vote217 views1 answer
Sql server port 1434
SQL
1 vote236 views1 answer
Sql server if exists update else insert
SQL
0 vote211 views1 answer
Acual month sql
SQL
0 vote242 views1 answer
SQL Where-Klausel
SQL
0 vote205 views1 answer
Mysql autoincrement valor inicial
SQL
1 vote210 views1 answer
Psql connect to another database
SQL
0 vote225 views1 answer
Postgres get database encoding
SQL
0 vote216 views1 answer
Raven ql select count
SQL