MySQL查询所有库中表名

select table_name from information_schema.tables where table_schema='contract_ggpt' and table_type='base table'
原文地址:https://www.cnblogs.com/lixx/p/8432169.html