mysql中如何查询数据库中的表名

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；
-- use 数据库名
USE sakila;
SHOW TABLES;

SELECT
  TABLE_NAME
FROM
  information_schema. TABLES
WHERE
  table_schema = '数据库名';

mysql> select table_name from information_schema.tables where table_schema = 'sakila';
+----------------------------+
| TABLE_NAME         |
+----------------------------+
| actor           |
| actor_info         |
| address          |
| category          |
| city            |
| country          |
| customer          |
| customer_list       |
| film            |
| film_actor         |
| film_category       |
| film_list         |
| film_text         |
| inventory         |
| language          |
| nicer_but_slower_film_list |
| payment          |
| rental           |
| sales_by_film_category   |
| sales_by_store       |
| staff           |
| staff_list         |
| store           |
+----------------------------+
23 rows in set (0.00 sec)

mysql> select table_name from information_schema.tables where table_schema = 'sakila' or table_schema = 'test';
+----------------------------+
| TABLE_NAME         |
+----------------------------+
| actor           |
| address          |
| category          |
| city            |
| country          |
| customer          |
| film            |
| film_actor         |
| film_category       |
| film_text         |
| inventory         |
| language          |
| payment          |
| rental           |
| staff           |
| store           |
| customer_list       |
| film_list         |
| nicer_but_slower_film_list |
| staff_list         |
| sales_by_store       |
| sales_by_film_category   |
| actor_info         |
| employee          |
| test_alter         |
+----------------------------+
25 rows in set (0.01 sec)