Click here to watch in Youtube : https://www.youtube.com/watch?v=9gueIEwUHnA&index=2&list=UUhwKlOVR041tngjerWxVccw
Click the below Image to Enlarge
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFeJnZXEXLQXQP0WkZ6ty0zrkrmSOtDrmpovN1uKhuGooGyjJ-zNTkjdMIFOY31ms1VggVwt-X5fzVa7Tvg-FQSKfDYxOoA_olviVNiZmhK9LcnCH5sFp_86PdCXdHa6yVlw_3CuRq4so/s640/Mysql+-+Stored+Procedure+with+Input+and+Output+Parameters.jpg) |
Mysql - Stored Procedure with Input and Output Parameters |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhP_8ogz-HwE1936gIWlZMOIVKwXkZsvSBnTNYBpjRdUyfZIbZzATFi_3A4ZulRsPLSjNs-7VmBtRK0MCdYqqpe4lwt9Qa7A3qF-PS0qQG2TEg2CiYSp0mmnfcSeL6n9NXKf7Vu4O4vgAs/s640/Mysql+-+Stored+Procedure+with+Input+and+Output+Parameters.jpg) |
Mysql - Stored Procedure with Input and Output Parameters |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOCQOf2vhX1vZ7JGEDVUR0TC_C9t8CYlRoXj5Srvpd6STl9ZR_NRH1VFIbB0F2RNAv4JGTEXnlnC_dZyTwTU62dhnNZY2wzvNY-6-ln00hXjScNt9m3ESmXBbLeYP38CQfXnZzy0V_RAw/s640/Mysql+-+Stored+Procedure+with+Input+and+Output+Parameters.jpg) |
Mysql - Stored Procedure with Input and Output Parameters |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEcny6zwbIN3-NDC12mfOSWU2d3M33rPvZgevhV3Ah6HKjJSsHVugGZ8XieEEkTlmHdb3sjYnRTr0bZONYmiQslmirv1UCuJQCNDL_64pXEt80YraAlrs4-_wcESy9ZNNLrUQRDwg7RPE/s640/Mysql+-+Stored+Procedure+with+Input+and+Output+Parameters.jpg) |
Mysql - Stored Procedure with Input and Output Parameters |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2Le2aPmMvxCVkpvKplTLAkU6DCQqxy2Z6W3Owfl1PJsm92ZKz08ph4H4Qf9G-RRKoEt9s5-XEMjwBTOKSxNzPGrKlwUVnd1HjScNQjo9C4wHCFsAcwWdjuaqS0kjwgxjki0dhHS2IIv0/s640/Mysql+-+Stored+Procedure+with+Input+and+Output+Parameters.jpg) |
Mysql - Stored Procedure with Input and Output Parameters |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmDnmwVcS8wb91kYPmarwG-4ueasCmBvfTGtm56BE70cUuNRVDEX6l3nvIhb8krJ6sD3AcfS0Oths1oU2MKi1DlLdU-UNTbF1SlROa_Qv6w8gCWFI3iVa4nPcIs8PBXofmmwV1Hy1-TGY/s640/Mysql+-+Stored+Procedure+with+Input+and+Output+Parameters.jpg) |
Mysql - Stored Procedure with Input and Output Parameters |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNMhslsrQmOEq0YVbAfT6C7SWVfQZlanpd4XH4KMVjaiBYuam1pEb3a-fDW3UXUpG7-Bu-HT0RPLEMYK_qbWJvA-Ytg_rR5BMCxsji_29BD555i0lPnqoEOQySQnikXXNi6S76unvmmX8/s640/Mysql+-+Stored+Procedure+with+Input+and+Output+Parameters.jpg) |
Mysql - Stored Procedure with Input and Output Parameters |
DELIMITER $$
DROP PROCEDURE IF EXISTS `world`.`getCityName` $$
CREATE PROCEDURE `world`.`getCityName`
(IN CITY_ID INT, OUT CITY_NAME VARCHAR(255))
BEGIN
SELECT Name INTO CITY_NAME
FROM city
WHERE ID = CITY_ID;
END $$
DELIMITER ;
----------------------------------------------------------
set @CITY_ID=3;
call getCityName(@CITY_ID,@CITY_NAME);
select @CITY_NAME;
very good video and details
ReplyDeletemobile and website application developer