MySQL Forums
Forum List  »  Stored Procedures

mysql stored procedure problem
Posted by: dhiraj danode
Date: August 30, 2007 02:36AM

I have writeen this stored procedure in my one php program

DELIMITER $$

DROP PROCEDURE IF EXISTS `test` $$
CREATE PROCEDURE `test` ()
BEGIN
DECLARE var varchar(50) DEFAULT 'name_first';
SELECT var FROM care_person WHERE var = 'aaaaa';
END $$

DELIMITER ;

as i declare varibale var as name_first and i want to use that variable in my mysql query but it didnt working

pl help me

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql stored procedure problem
1847
August 30, 2007 02:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.