/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

1 vote260 views1 answer
Sample in sql
SQL
0 vote284 views1 answer
Varchar2 length in oracle
SQL
1 vote275 views1 answer
Increase existing date in sql oracle
SQL
2 votes252 views2 answers
Insert all in sql
SQL
2 votes275 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
5 votes252 views2 answers
Oracle to_timestamp
SQL
1 vote275 views1 answer
How to update date add hours in postgresql
SQL
1 vote273 views1 answer
Check if mysql is installed
SQL
0 vote271 views1 answer
Sql clear table
SQL
2 votes298 views1 answer
Postgresql create table as select
SQL