/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 vote331 views1 answer
Executescalar in sql server
SQL
7 votes331 views1 answer
Alter sequence set current value oracle
SQL
0 vote327 views1 answer
Pl sql round
SQL
1 vote329 views1 answer
Sql alchemy with azuresql server
SQL
2 votes308 views1 answer
Get first 3 letters name in sql
SQL
0 vote342 views1 answer
Intellij idea add mysql connector
SQL
0 vote293 views1 answer
Create dabase postgresql
SQL
12 votes357 views5 answers
Rename table in mysql
SQL
12 votes331 views2 answers
Find duplicates mysql column
SQL
0 vote414 views1 answer
TSQL Find csv file in folder
SQL