/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 vote170 views1 answer
Sql avg group by
SQL
0 vote187 views1 answer
Narural join
SQL
0 vote212 views1 answer
Mysql relationships between tables
SQL
0 vote189 views1 answer
Mariadb maximum left join
SQL
0 vote190 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote168 views1 answer
Get number of rows in every table mysql
SQL
1 vote166 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
9 votes192 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote691 views1 answer
T sql less than date
SQL
0 vote194 views1 answer
Sql server on mac m1
SQL