DELIMITER $$
DROP PROCEDURE IF EXISTS `spCurrentTeamValue` $$
CREATE PROCEDURE `spMy`(IN sid INT)
BEGIN
  SELECT consumer_number,name,address,contact_mobile,subare aid,
  ownership,hometype,num_cfl_type1,num_cfl_type2,num _icl_type1,num_icl_type2,
  payment_received,distribution_completed,participat ion, non_participating_reason,registeredr,registereddat e
  FROM cpa_consumerinfo
  WHERE subareaid =sid;
END $$
DELIMITER ;

CALL spMy(1);