/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

2 votes327 views1 answer
Dbms transaction (psql)
SQL
0 vote324 views1 answer
Get initials name in sql
SQL
1 vote314 views2 answers
Drop function in sql
SQL
0 vote285 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote282 views1 answer
Format the money fied with comma in international system using sql
SQL
9 votes327 views4 answers
Mysql set id auto increment
SQL
4 votes252 views1 answer
And or sql order of operations
SQL
1 vote309 views3 answers
Drop unique key constraint in sql server
SQL
0 vote314 views2 answers
Search stored procedures
SQL
15 votes302 views6 answers
Drop foreign key mysql
SQL