MySQL Forums
Forum List  »  Docs

Advanced Search
New Topic

Re: is there a way to evaluate query results back into the query string?
Posted by: Mike Hillyer
Date: October 18, 2004 08:59AM

This is not possible, and I do not even think such behaviour would conform to the SQL standard. If your design is sound you will need to do the concat on the client side. The reason I say if you design is sound is because the need to dynamically generate a table name could indicate that you need to normalize your design or at least review why you would need to concat the table name to begin with.

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535

Blog: http://www.openwin.org/mike

"The Open Source movement has become a major force across the software industry, and MySQL is the world's most popular open source database."
--Fortune Magazine

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


Subject
Views
Written By
Posted
is there a way to evaluate query results back into the query string?
7453
edward anastas
September 08, 2004 12:51PM
Re: is there a way to evaluate query results back into the query string?
3505
Mike Hillyer
October 18, 2004 08:59AM


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.