/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 vote167 views1 answer
Spring postgresql reset auto increment to 0
SQL
2 votes176 views1 answer
Mysql set value as null
SQL
12 votes230 views2 answers
Update column data type postgres
SQL
1 vote177 views2 answers
Sql convert datetime to year month
SQL
0 vote236 views1 answer
Oracle sqlp update amount / quantity
SQL
21 votes142 views7 answers
Table drop if exist sql server
SQL
2 votes184 views1 answer
Docker run postgres locally
SQL
0 vote171 views1 answer
Sql server check whether column has same equal values
SQL
0 vote192 views2 answers
Unique key
SQL
0 vote163 views1 answer
Mysql multiple count
SQL