/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 vote284 views1 answer
Postgres set column based on another column
SQL
4 votes162 views2 answers
Error loading MySQLdb module.
SQL
0 vote184 views1 answer
Day of the week sqlite
SQL
16 votes179 views3 answers
Get count of duplicate records
SQL
0 vote185 views1 answer
Mysql config slave
SQL
1 vote190 views1 answer
Is sql fast
SQL
1 vote163 views1 answer
How to group by month using sql server
SQL
1 vote152 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
1 vote215 views1 answer
Mysql connect command
SQL
0 vote187 views1 answer
What is common table expression in sql
SQL