查询一个数据库中含有某关键词的表名
搜索一个数据库中包含一些关键字,词的表。
SELECT
TABLE_NAME
FROM
information_schema. TABLES
WHERE
table_schema = '数据库名'
AND TABLE_NAME LIKE '%name%';
例
mysql> select table_name from information_schema.tables
-> where table_schema = 'sakila'
-> and table_name like "%film%";
+----------------------------+
| TABLE_NAME |
+----------------------------+
| film |
| film_actor |
| film_category |
| film_list |
| film_text |
| nicer_but_slower_film_list |
| sales_by_film_category |
+----------------------------+
7 rows in set (0.00 sec)
查询数据库中所有的表
- show tables;