Guest User

Untitled

a guest
Nov 19th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. CREATE TRIGGER check_whitelist AFTER INSERT ON t1
  2. FOR EACH ROW
  3. SELECT
  4. IF(IFNULL(new.name=(select name From t2
  5. where (t2.PLATE = new.name
  6. ),
  7. UPDATE t3 SET option1 =0 ,
  8. UPDATE t3 SET option2 =1
  9. )
  10. )
  11. )
Add Comment
Please, Sign In to add comment