MySQL Bugs: #12614: Dynamic Querying in SPs (EXECUTE)

Bug #12614	Dynamic Querying in SPs (EXECUTE)
Submitted:	17 Aug 2005 4:45	Modified:	16 Sep 2005 16:32
Reporter:	Chagh	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S4 (Feature request)
Version:	5.0.9	OS:	Windows (Win XP)
Assigned to:	Documentation Team	CPU Architecture:	Any

Description:
hi,
It would be great if Dynamic Querying could be done in Stored Procedures. Specially if a statement like EXECUTE can do it. I think this is vital for many projects.
Thanks

How to repeat:
hi,
It would be great if Dynamic Querying could be done in Stored Procedures. Specially if a statement like EXECUTE can do it. I think this is vital for many projects.
Thanks

Suggested fix:
hi,
It would be great if Dynamic Querying could be done in Stored Procedures. Specially if a statement like EXECUTE can do it. I think this is vital for many projects.
Thanks

Documentation status is not for documentation bugs but for bugs that require a changelog entry. Assigning to Docs team, changing category to Server:Docs, status to Verified.

Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).

Additional info:

As of MySQL 5.0.13, PREPARE/EXECUTE/DEALLOCATE PREPARE
can be used in stored procedures.  See:

http://dev.mysql.com/doc/mysql/en/routine-restrictions.html
http://dev.mysql.com/doc/mysql/en/news-5-0-13.html