/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 vote188 views1 answer
Sql server delete records with specific date
SQL
0 vote176 views1 answer
Sqlite3 now
SQL
1 vote181 views1 answer
Check message id sql server
SQL
0 vote197 views1 answer
Search In the Data using ObjectName
SQL
0 vote229 views1 answer
Sql create and grant user access to database
SQL
1 vote192 views2 answers
Change table name phpmyadmin
SQL
13 votes191 views5 answers
Select last row mysql
SQL
1 vote206 views1 answer
Print year of a date sql
SQL
0 vote231 views1 answer
How to change mysql root password in windows 10
SQL
1 vote207 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL