Guest User

Untitled

a guest
Jul 17th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. INSERT INTO alarms (status, type)
  2. SELECT * FROM (SELECT '2', '1') AS tmp
  3. WHERE NOT EXISTS
  4. ( SELECT type FROM alarms WHERE (type = '1')) LIMIT 1;
  5.  
  6. INSERT INTO alarms (status, type)
  7. SELECT * FROM (SELECT '2', '1') AS tmp
  8. WHERE NOT EXISTS
  9. ( SELECT type, status FROM alarms WHERE (type = '1' AND status = '5')) LIMIT 1;
  10.  
  11. If Not Exists( SELECT type, status FROM alarms WHERE (type = '1' AND status = '5'))
  12. Begin
  13. INSERT INTO alarms (status, type) values ("Y","type")
  14. End
Add Comment
Please, Sign In to add comment