How to select table from syntax show on mysql, without using procedure?

Question

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.

This should help: http://stackoverflow.com/questions/64894/select-data-from-show-tables-mysql-query — Ravinder Reddy, Sep 01 '14 at 07:15

score 1 · Accepted Answer · answered Sep 02 '14 at 11:14

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 }....

answered Sep 02 '14 at 11:14

Munees Majid

1 Answers1