本篇内容介绍了“Mysql怎么查询数据库中的表名”的有关知识,在实际案例的操作过程中,不少人都会遇到这样的困境,接下来就让小编带领大家学习一下如何处理这些情况吧!希望大家仔细阅读,能够学有所成!查询数据库中
本篇内容介绍了“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> 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)
“mysql怎么查询数据库中的表名”的内容就介绍到这里了,感谢大家的阅读。如果想了解更多行业相关的知识可以关注编程网网站,小编将为大家输出更多高质量的实用文章!
--结束END--
本文标题: mysql怎么查询数据库中的表名
本文链接: https://www.lsjlt.com/news/178835.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-14
2024-04-14
2024-04-14
2024-04-14
2024-04-14
2024-04-14
2024-04-14
2024-04-14
2024-04-14
2024-04-14
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0