Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER check_whitelist AFTER INSERT ON t1
- FOR EACH ROW
- SELECT
- IF(IFNULL(new.name=(select name From t2
- where (t2.PLATE = new.name
- ),
- UPDATE t3 SET option1 =0 ,
- UPDATE t3 SET option2 =1
- )
- )
- )
Add Comment
Please, Sign In to add comment