MySQL Forums
Forum List  »  Stored Procedures

prepare statement - table as wildcard
Posted by: Manhao Chen
Date: September 16, 2012 10:07PM

is this even possible?

BEGIN

SET @entity_name = Entity_Name_COL;
PREPARE STMT FROM "SELECT * FROM ?";
EXECUTE STMT USING @entity_name;

END



Edited 1 time(s). Last edit at 09/16/2012 10:07PM by Manhao Chen.

Options: ReplyQuote


Subject
Views
Written By
Posted
prepare statement - table as wildcard
1680
September 16, 2012 10:07PM


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.