From: Girish Talluru
Date: February 12 2013 6:33am
Subject: Variable manipulation in stored procedure
List-Archive: http://lists.mysql.com/mysql/228947
Message-Id: <CABenTqbvQDKFZDjPUZ==y2UtB-GCPv3QcX+PFYWMbm=sFWkHpg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=f46d044631705cfe4f04d58133c4

--f46d044631705cfe4f04d58133c4
Content-Type: text/plain; charset=ISO-8859-1

Hi All,

I have a variable in stored procedure named Project_Number and it is of
varchar type.

My Requirement is "for each project number query the table
project_Number_List get results from list and insert into other table"

Lets say, Project_Number might be like this 22,21,34,43,434
corresponding tables I need to query is something like this 22_List,
21_List,34_List .....

I'm using cursor to loop through the Project_Number but my problem is how
to mix the project_number and _list i.e., 22_list to query the table 22_List

Any suggestions?

Thanks,
Girish Talluru

--f46d044631705cfe4f04d58133c4--