/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 vote394 views1 answer
Fetching data from mysqldb
SQL
0 vote345 views1 answer
How to use select union and loop
SQL
0 vote341 views1 answer
Mysql could not fetch tables
SQL
1 vote299 views2 answers
Show sql logs in spring boot
SQL
2 votes351 views1 answer
How to make multiple keys as primary in bdms
SQL
2 votes368 views1 answer
Orcale index size
SQL
-1 vote381 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote375 views1 answer
Sql commands in android
SQL
1 vote379 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote334 views2 answers
Find Overlapping sql
SQL