Y
Y
Yermek2015-12-04 18:37:06
MySQL
Yermek, 2015-12-04 18:37:06

Is it correct to pull out a list of tables with a condition?

Is it correct to pull out a list of tables with a query

show tables where Tables_in_<db_name> like 'prefix%'

Or is there a better way to use?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Max, 2015-12-04
@ermek6

fine.
alternative - SELECT from INFORMATON_SCHEMA

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question