mysql数据库命令查看数据库信息。

最新推荐文章于 2024-07-29 17:00:09 发布

suyu_yuan

最新推荐文章于 2024-07-29 17:00:09 发布

阅读量3.9k

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/suyu_yuan/article/details/51784932

版权

MySQL 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

1、通过sql查看数据库的所有表名：

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '数据库名'
;

或者：

SHOW TABLES;

SHOW DATABASES;
SHOW TABLES FROM test;
SHOW CREATE TABLE t_blog;

CREATE TABLE `t_blog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1

SHOW TABLE STATUS FROM test;
SHOW COLUMNS FROM t_blog FROM test;
SHOW FULL COLUMNS FROM t_blog FROM test;
SHOW FIELDS FROM t_blog FROM test;
SHOW FULL FIELDS FROM t_blog FROM test;
DESCRIBE t_blog;
DESCRIBE t_blog age;
SHOW INDEX FROM t_blog FROM test;
SHOW STATUS;
SHOW VARIABLES;
SHOW PROCESSLIST;
SELECT USER();
SHOW GRANTS FOR root@localhost;