/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 vote145 views1 answer
Sqlite unique multiple columns
SQL
7 votes123 views1 answer
Oracle set sequence value to max(id)
SQL
1 vote128 views1 answer
Base64 encode sql server
SQL
0 vote121 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote123 views1 answer
Search from comma separated values in sql server
SQL
0 vote137 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote157 views1 answer
Sqlite update where exists
SQL
0 vote142 views1 answer
Sql cmd no truncate
SQL
0 vote127 views1 answer
Sql select merge multiple values
SQL
-1 vote135 views1 answer
Default username and password for oracle 11g
SQL