/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

1 vote190 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote201 views1 answer
Mysql query single row
SQL
8 votes202 views1 answer
Script to add datafile to tablespace
SQL
0 vote257 views1 answer
Oracle job session
SQL
1 vote271 views1 answer
Size of all tables in a schema oracle
SQL
0 vote182 views1 answer
How to connect postgresql database with java
SQL
8 votes288 views1 answer
Insert a select statement into a table
SQL
0 vote255 views1 answer
Sql count matching group by
SQL
0 vote366 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote181 views1 answer
SQL server select to get sum of hours
SQL