mysql - 查询是否存在多个表

Question

我需要编写一个查询，以便在我要求的所有表都存在的情况下返回结果。我知道这个存在:

show tables like 'user'

只是不确定如何为多个表扩展它。我知道这是无效代码，但类似

show tables like 'user' AND show tables like 'site' AND ...

谢谢!

Answer 1

select * 
from information_schema.tables
where table_name in ('tb1','tb2','tb3') 
and table_schema = 'your_db'
having count(table_name) = 3

嗯，我意识到那个查询有问题。如果所有表都存在，它只返回一条记录。这将是一个更好的解决方案

select group_concat(table_name order by table_name) as table_list
from information_schema.tables
where table_name in ('tb1','tb2','tb3') 
and table_schema = 'your_db'
having count(*) = 3