/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

14 votes370 views1 answer
How to export db from mysql
SQL
1 vote291 views2 answers
Drop table if exists test
SQL
1 vote308 views1 answer
Sql headers delphi
SQL
5 votes255 views1 answer
Alter table default value mysql
SQL
-1 vote325 views4 answers
Sql view postgresql
SQL
0 vote282 views1 answer
Google cloud sql postgres url example
SQL
0 vote285 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
1 vote313 views1 answer
Sql string function update replace
SQL
0 vote238 views1 answer
Check id exist or not in sql
SQL
0 vote317 views1 answer
Mysql remove last character
SQL