/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 vote294 views1 answer
Check if a word appears at the end sql query
SQL
0 vote320 views1 answer
Get create sql of hibernqte entity
SQL
2 votes319 views1 answer
Sqlite insert if not exists
SQL
0 vote366 views1 answer
Virtuoso sql query tutorial
SQL
0 vote315 views1 answer
Regex mongoose
SQL
8 votes351 views3 answers
SQL column name
SQL
-1 vote265 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote314 views3 answers
Insert query in ci
SQL
12 votes370 views4 answers
How to drop all tables in postgresql
SQL
2 votes324 views3 answers
Copy data from one table column to another table column in sql
SQL