/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

6 votes177 views3 answers
Sql select last id
SQL
0 vote164 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote161 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
5 votes172 views3 answers
Oracle list columns in schema
SQL
0 vote159 views1 answer
Get records in sql according to month name and count
SQL
0 vote166 views1 answer
Python list from sql
SQL
8 votes162 views1 answer
Oracle add months to sysdate
SQL
19 votes168 views5 answers
Change column name mysql command line
SQL
8 votes160 views5 answers
Grant permission in postgres
SQL
0 vote210 views1 answer
Update mysql from paypal shopping cart and ipn
SQL