开发者

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;

    同上面,where条件只查数据库名。还可以同时搜索多个数据库中的表。

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

    例:

    mysql&gjavascriptt; 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        开发者_SQLite   |
    | 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         |
    +-----------------js-----------+
    | 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         |
    | emp编程客栈loyee          |
    | test_alter         |
    +----------------------------+
    25 rows in set (0.01 sec)

    总结

    以上为个人经验,希望能给大家一个参考,也希望大家多多支持我们。

    0

    上一篇:

    下一篇:

    精彩评论

    暂无评论...
    验证码 换一张
    取 消

    最新数据库

    数据库排行榜