Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELETE FROM `PHONE` WHERE `PHONE`.`USER_ID` in (SELECT `USER`.`ID` FROM `USER` WHERE `EMAIL` in("wmxtestone@gmail.com","wmxtesttwo@gmail.com")) ;
- DELETE FROM `PHONE` WHERE `PHONE`.`CONTACT_ID` in (SELECT `CONTACT`.`id` FROM `CONTACT` WHERE `CONTACT`.`USER_ID` in (SELECT `USER`.`ID` FROM `USER` WHERE `EMAIL` in("wmxtestone@gmail.com","wmxtesttwo@gmail.com"))) ;
- DELETE FROM `CONTACT` WHERE `CONTACT`.`USER_ID` in (SELECT `USER`.`ID` FROM `USER` WHERE `EMAIL` in("wmxtestone@gmail.com","wmxtesttwo@gmail.com")) ;
- DELETE FROM `AVATAR` WHERE `AVATAR`.`USER_ID` in (SELECT `USER`.`ID` FROM `USER` WHERE `EMAIL` in("wmxtestone@gmail.com","wmxtesttwo@gmail.com")) ;
- DELETE FROM `USER` WHERE `EMAIL` in("wmxtestone@gmail.com","wmxtesttwo@gmail.com");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement