/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 vote269 views1 answer
Plpgsql raise notice
SQL
2 votes283 views1 answer
Oracle Column Names of a table
SQL
1 vote210 views1 answer
Mysql see column types
SQL
0 vote256 views1 answer
Sql values not in another table
SQL
0 vote261 views1 answer
SAP Return
SQL
0 vote243 views1 answer
Search db for table name
SQL
1 vote279 views1 answer
Oracle see column type
SQL
0 vote237 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote273 views1 answer
Psotgres multiple values
SQL
0 vote240 views4 answers
How to drop all tables in sql
SQL