MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Creating a FUNCTION where table names can vary?
Posted by: Andrew Gilfrin
Date: March 27, 2006 05:41AM

You need to use dynamic SQL via a prepared statement, search the procedures forum for more details or for a general view of the principles look here.

http://mysql.gilfster.com/page.php?parent_id=1.3&page_id=1.3.6

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

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


Subject
Written By
Posted
Creating a FUNCTION where table names can vary?
AJ M
March 25, 2006 11:23PM
Re: Creating a FUNCTION where table names can vary?
Andrew Gilfrin
March 27, 2006 05:41AM


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.