Guest User

Untitled

a guest
Jul 16th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. CREATE DEFINER=`root`@`localhost` PROCEDURE `login`(in uname_email varchar(45), in pass varchar(45))
  2.  
  3. BEGIN
  4.  
  5. DECLARE result BOOL;
  6.  
  7. IF EXISTS(SELECT * FROM registration_table WHERE (Username or Email=uname_email) and Pass=pass)THEN
  8.  
  9. SET result=TRUE;
  10.  
  11. SELECT result;
  12.  
  13. ELSE
  14. BEGIN
  15. SET result=FALSE;
  16. SELECT result;
  17. END;
  18. END IF;
  19. END
Add Comment
Please, Sign In to add comment