Friday 8 May 2015

Mysql - Stored Procedure with multiple Input Parameters

Click here to watch in Youtube : https://www.youtube.com/watch?v=UFrKfcCch8w&index=3&list=UUhwKlOVR041tngjerWxVccw

Click the below Image to Enlarge
Mysql - Stored Procedure with multiple Input Parameters
Mysql - Stored Procedure with multiple Input Parameters
Mysql - Stored Procedure with multiple Input Parameters
Mysql - Stored Procedure with multiple Input Parameters
Mysql - Stored Procedure with multiple Input Parameters
Mysql - Stored Procedure with multiple Input Parameters
Mysql - Stored Procedure with multiple Input Parameters


DELIMITER $$

CREATE PROCEDURE `getCityInfo` (IN POPULATION_INPUT INT,IN COUNTRY_CODE_INPUT VARCHAR(255))
BEGIN

select Name,District from city where Population = POPULATION_INPUT and
Countrycode = COUNTRY_CODE_INPUT;

END



CALL `world`.`getCityInfo`(4000, 'NLD');
See also:

  • All JavaEE Viedos Playlist
  • All JavaEE Viedos
  • All JAVA EE Links
  • Servlets Tutorial
  • All Design Patterns Links
  • JDBC Tutorial
  • Java Collection Framework Tutorial
  • No comments:

    Post a Comment