Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DEFINER=`root`@`localhost` PROCEDURE `test`(
- IN `Param1` INT,
- IN `Param2` INT,
- IN `Param3` INT
- )
- LANGUAGE SQL
- NOT DETERMINISTIC
- READS SQL DATA
- SQL SECURITY DEFINER
- COMMENT 'this is for testing'
- BEGIN
- SELECT * from user_ us where us.userId = Param1 ;
- SELECT * from contact_ c where c.contactId =Param2;
- select * from account_ ac where ac.accountId = Param3;
- END
Add Comment
Please, Sign In to add comment