MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Stored procedure with variable table name
Posted by: Peter Brawley
Date: May 05, 2017 10:54AM

Read your own params. I you still don't understand, after @getID=..., add ...

select @getID;

comment out the Prepare block, and run it with your arbitrary strings.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Stored procedure with variable table name
19311
Bob Barker
May 02, 2017 09:23AM
Re: Stored procedure with variable table name
3343
Peter Brawley
May 02, 2017 09:51AM
Re: Stored procedure with variable table name
2727
Bob Barker
May 03, 2017 03:31PM
Re: Stored procedure with variable table name
1922
Peter Brawley
May 05, 2017 10:54AM


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.