/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 vote349 views1 answer
Copy data from cell to cell mysql
SQL
0 vote374 views2 answers
Create-toys-table-with-toy_name-column
SQL
11 votes341 views1 answer
Oracle insert into where
SQL
0 vote355 views2 answers
Postgresql gset
SQL
1 vote338 views2 answers
Datetrunc hour snowflake
SQL
1 vote373 views1 answer
Login to database mysql terminal
SQL
0 vote360 views2 answers
Start mysql server using docker
SQL
0 vote340 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
4 votes324 views1 answer
Oracle error compilation line
SQL
0 vote337 views1 answer
Dump db only triggers mysql
SQL