0

i have read this article Select data from “show tables” MySQL query . But i need to get table from show tables. I try this syntax at the first.

show tables from pos where tables_in_pos like (select kdtk from toko)

and then the value has show

+-------------------+
| tables_in_pos |

+-------------------+
| fnpk |

after that i try this syntax

select * from concat(show tables from pos where tables_in_pos like (select kdtk from toko),'a') as Hasil

How to select table from syntax Show on mysql? without using Procedure.

Improve this question
2

1 Answer 1

Reset to default
1

Use the query as follows,You need to include conditions in your query to get them the way you want:

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='your DB_Name' AND........{additional conditions }....
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.