Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DEFINER=`root`@`localhost` PROCEDURE `login`(in uname_email varchar(45), in pass varchar(45))
- BEGIN
- DECLARE result BOOL;
- IF EXISTS(SELECT * FROM registration_table WHERE (Username or Email=uname_email) and Pass=pass)THEN
- SET result=TRUE;
- SELECT result;
- ELSE
- BEGIN
- SET result=FALSE;
- SELECT result;
- END;
- END IF;
- END
Add Comment
Please, Sign In to add comment