Guest User

Untitled

a guest
May 21st, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. CREATE DEFINER=`root`@`localhost` PROCEDURE `test`(
  2. IN `Param1` INT,
  3. IN `Param2` INT,
  4. IN `Param3` INT
  5. )
  6. LANGUAGE SQL
  7. NOT DETERMINISTIC
  8. READS SQL DATA
  9. SQL SECURITY DEFINER
  10. COMMENT 'this is for testing'
  11. BEGIN
  12. SELECT * from user_ us where us.userId = Param1 ;
  13. SELECT * from contact_ c where c.contactId =Param2;
  14. select * from account_ ac where ac.accountId = Param3;
  15. END
Add Comment
Please, Sign In to add comment