/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

0 vote122 views1 answer
Oracle query to find schema you are working on
SQL
0 vote118 views1 answer
Create domain sql
SQL
0 vote119 views1 answer
Sql server select ignore dupplicates
SQL
4 votes107 views2 answers
Postgresql reset sequence
SQL
23 votes127 views1 answer
How remove column in mysql
SQL
0 vote114 views1 answer
Object Information
SQL
0 vote120 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote108 views2 answers
Sqlalchemy core in clause
SQL
0 vote124 views1 answer
Sql cnvert bit to nvarchar
SQL
2 votes116 views1 answer
Oracle apex list connected users
SQL