WELL I AM TRYING TO DO THIS BUT NOT GETTING ANY RESPONSE FORM SERVER
DELIMITER //
CREATE PROCEDURE getchgp(in ol varchar(100),in nw varchar(100),in sch varchar(100),out res varchar(100))
BEGIN
SELECT pass INTO res FROM registration WHERE pass=ol AND schno=sch;
UPDATE registration SET pass=nw WHERE schno=sch AND pass=ol;
END //
DELIMITER ;
PLEASE HELP ME OUT ..............