/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

15 votes311 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote177 views1 answer
Mysql type for large numbers with many decimal
SQL
1 vote159 views1 answer
Mysql date diff in seconds
SQL
0 vote166 views1 answer
Oracle last connection
SQL
0 vote179 views1 answer
Mysql docker image arjun
SQL
1 vote170 views1 answer
Select not matching data from two tables
SQL
8 votes167 views2 answers
Change name of colum in sql table
SQL
0 vote176 views1 answer
Sql select column name like from multiple tables
SQL
0 vote177 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote169 views1 answer
Comma seperated join mssql
SQL