DELIMITER //
CREATE PROCEDURE aff2_2015
(IN con longtext, IN mob bigint)
BEGIN
SELECT * FROM affidavitdata_2015
WHERE studentFirstName = con and studentmobilenumber=mob;
END //
DELIMITER ;
CALL aff2_2015('nishant','7503485910');
CREATE PROCEDURE aff2_2015
(IN con longtext, IN mob bigint)
BEGIN
SELECT * FROM affidavitdata_2015
WHERE studentFirstName = con and studentmobilenumber=mob;
END //
DELIMITER ;
CALL aff2_2015('nishant','7503485910');
No comments:
Post a Comment