/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

4 votes158 views5 answers
Primary key
SQL
0 vote165 views2 answers
Reseed sql identity
SQL
4 votes235 views2 answers
Sql select except null
SQL
0 vote136 views1 answer
Cara menampilkan user di mysql terminal
SQL
3 votes147 views2 answers
Brew start mysql
SQL
0 vote171 views1 answer
Second Step in installing SQL workbench
SQL
0 vote154 views1 answer
Closure in sql
SQL
11 votes148 views5 answers
Laravel db facade
SQL
0 vote159 views1 answer
Exectuer myssql .sql
SQL
0 vote144 views1 answer
Lost connection to mysql
SQL