dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Sep 28, 2018

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


Get Detailed Information on Tables in MySQL

MySQL provides a schema named information_schema. This has a table named TABLES that has detailed information on the available tables, their record count, etc.

The query below helps you with the information on the table_schema, table_name and the record count.

SELECT table_schema, table_name, table_rows FROM information_schema.tables

Output: Truncated output
+---------------------+------------------------------------------------------+------------+
| table_schema        | table_name                                           | table_rows |
+---------------------+------------------------------------------------------+------------+
| information_schema  | CHARACTER_SETS                                       |       NULL |
| information_schema  | COLLATIONS                                           |       NULL |
| information_schema  | COLLATION_CHARACTER_SET_APPLICABILITY                |       NULL |
| information_schema  | COLUMNS                                              |       NULL |
| information_schema  | COLUMN_PRIVILEGES                                    |       NULL |
| information_schema  | ENGINES                                              |       NULL |
+---------------------+------------------------------------------------------+------------+
645 rows in set (0.35 sec) 
M S Sridhar
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date