Member Avatar for dev.vini 
DROP PROCEDURE IF EXISTS `uniqueId`;


DELIMITER $$
	
CREATE PROCEDURE `unique`(IN deepak VARCHAR(100),OUT UNIQUEID INT)
BEGIN

	SELECT UNIQUEID FROM products WHERE PRODNUM='deepak';

END$$
DELIMITER ;

how to select uery work in this procedure.............help me

Edited by Ezzaral because: Added code tags. Please use them to format any code that you post.
  • 2 Contributors
  • 1 Reply
  • 60 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by smantscheff
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.