Home >Database >Mysql Tutorial >mysql中查询数据库下所有的表_MySQL
mysql中查询数据库下所有的表_MySQL
- WBOYOriginal
- 2016-06-01 13:18:141379browse
bitsCN.com
老是忘记，这里做个备注！
1、首先查看数据库
show databases;
2、进入数据库
use db_name;
3、显示所有的表
show tables;bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL之thread cache_MySQLNext article：MYSQL多实例配置与使用教程_MySQL