MySQL Forums
Forum List  »  Stored Procedures

Re: help with procedure and tablename
Posted by: Jay Pipes
Date: February 10, 2006 11:26AM

Andre Timmer wrote:
> To my knowledge dynamic sql is not possible.

Yes it is. Use the PREPARE syntax:

http://dev.mysql.com/doc/refman/5.0/en/sqlps.html

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Options: ReplyQuote


Subject
Views
Written By
Posted
2195
February 10, 2006 02:45AM
1455
February 10, 2006 06:12AM
Re: help with procedure and tablename
1308
February 10, 2006 11:26AM
1938
February 10, 2006 01:38PM
1344
February 10, 2006 01:51PM
1364
February 10, 2006 04:25PM
1319
February 12, 2006 01:03AM
1375
February 12, 2006 03:16AM


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.