What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-19 02:54:08
how to use a trigger to validate input data
DELIMITER $$ CREATE TRIGGER example_before_insert_allow_only_one_active BEFORE INSERT ON example_tbl FOR EACH ROW BEGIN IF NEW.active = 1 AND (SELECT COUNT(id) FROM example_tbl WHERE active=1 AND foreign_key_id=NEW.for... Add solution