/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

2 votes145 views1 answer
Oracle drop table free up space
SQL
0 vote162 views1 answer
Sub query in linq
SQL
4 votes142 views3 answers
Sql find second highest salary employee
SQL
-1 vote161 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
3 votes141 views2 answers
Sql paging query
SQL
0 vote154 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
1 vote163 views1 answer
Myql find duplicates
SQL
0 vote143 views1 answer
How to find username and password in oracle 18c
SQL
0 vote146 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote108 views1 answer
Flask_sqlalchemy install
SQL