/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 vote295 views1 answer
Delete hangfire retries list
SQL
0 vote278 views1 answer
Csv to sqlite python
SQL
-1 vote266 views3 answers
SQL to LINQ converter
SQL
2 votes256 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote263 views1 answer
Postgres data location
SQL
1 vote265 views2 answers
Mysql error 1215
SQL
0 vote268 views1 answer
Mysql grant grant option
SQL
0 vote269 views1 answer
Sql case sttement with set
SQL
1 vote292 views1 answer
Primary key with prefix sql
SQL
0 vote284 views1 answer
Load data infile mariadb slow
SQL