MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Use result of show tables from database_name as table
Posted by: Deepanshu Kumar
Date: May 15, 2018 05:55AM

How can I use the result of
show tables from database_name; as a table to run further queries.
i have tried using it as subquery and also as a cte but none of the query worked.
Can anyone help????/

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




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.