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;