Guest User

Untitled

a guest
Feb 7th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. CREATE DEFINER=`U03zcv`@`%` PROCEDURE `check_Login`(in checkUser varChar(50), in checkPass varChar(50), out getResult int)
  2. BEGIN
  3. select COUNT(*) into @getResult from user where userName = @checkUser and `password` = @checkPass;
  4. END
  5.  
  6. set @checkUser = 'test';
  7. set @checkPass = 'test';
  8. call `check_Login` (@checkUser,@checkPass,@result);
  9. select @result;
Add Comment
Please, Sign In to add comment