Creating Stored Procedure in Mysql
I hope this will be helpful for the beginners who are just starting their career with mysql . DELIMITER $$ CREATE PROCEDURE usp_logout ( IN iInputType INT ) BEGIN IF (iInputType=1) THEN SELECT * FROM TEST1; ELSEIF (iInputType=2) THEN SELECT * FROM TEST2; ELSE SELECT FALSE; END IF; END$$