Guest User

Untitled

a guest
Dec 7th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. SELECT placeid, placename FROM place WHERE userid = (SELECT id FROM
  2. user WHERE username = 'username' AND password ='password') AND
  3. placename = 'placename'
  4.  
  5. SELECT boxid, boxname FROM box WHERE placeid = 'id'
  6.  
  7. DELETE FROM item WHERE boxid = 'boxid'
  8.  
  9. DELETE FROM box WHERE id = 'boxid'
  10.  
  11. DELETE FROM item WHERE placeid = 'placeid' AND boxid = 0
  12.  
  13. DELETE FROM place WHERE id = placeid
Add Comment
Please, Sign In to add comment