/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
Table structure in sql
SQL
-1 vote141 views2 answers
Postgresql get last 10 records
SQL
0 vote141 views1 answer
Oracle synonym procedure dblink
SQL
2 votes123 views1 answer
How to delete columns in sql
SQL
5 votes172 views3 answers
Sql limit offset
SQL
1 vote136 views1 answer
ORA-01950
SQL
7 votes135 views1 answer
Sql management studio display line numbers
SQL
3 votes123 views1 answer
Oracle failed login attempts
SQL
7 votes146 views1 answer
Query delete duplicates
SQL
0 vote134 views1 answer
Fast sql column count
SQL