Home > Database > Mysql Tutorial > mysql查看数据库表的数量命令_MySQL

mysql查看数据库表的数量命令_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-01 13:18:04
Original
1276 people have browsed it

bitsCN.com

有时候导入SQL文件后,表很多。想看看表的个数时候和服务器上表的个数是否相同。在mysql中可以用如下命令查看表的个数:

   SELECT count(TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA='dbname'; 
Copy after login



bitsCN.com
Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template