查询mysql数据库中所有表名

2019-10-09 本文已影响0人织雾呀

SELECT table_name 
FROM   information_schema.tables 
WHERE  table_schema = '数据库名字' 
       AND table_name LIKE '表名';