/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

18 votes222 views3 answers
Mysql query add column with default string value
SQL
10 votes211 views2 answers
Mysql select timestamp group by day
SQL
2 votes276 views1 answer
Python sql
SQL
0 vote214 views1 answer
How to see the query of a view in mysql
SQL
0 vote236 views1 answer
Sql select most frequent value in column
SQL
2 votes228 views2 answers
Postgres drop column if exists
SQL
0 vote223 views1 answer
Use where instead of join
SQL
2 votes254 views2 answers
How to run postgresql in linux
SQL
0 vote236 views1 answer
Set a value by excuting stored procedure
SQL
8 votes216 views2 answers
Phpmyadmin password
SQL