MySQL View database objects (SQL command Summary)

MySQL View database objects (SQL command Summary)
Data objects include tables, views, triggers, and so on (view statistics must go into the INFORMATION_SCHEMA database)

For an example of viewing table-related information, proceed as follows
1. Using INFORMATION_SCHEMA Database
Use INFORMATION_SCHEMA;

2. Query the size of all data (MB):

3. View the size of the specified database (schema) in megabytes:

Select Concat (Round (sum (data_length/1024/1024), 2), ' MB ') as db_size from tables where table_schema= ' EHR ';

4. View the size of the specified table (table) for the specified database

Select Concat (Round (sum (data_length/1024/1024), 2), ' MB ') as table_size from tables where table_schema= ' EHR ' and Table_ Name= ' Ehr_age ';

Of course, more than a single SQL to view the statistics is the current UI interface, there is one, the actual thing or the SQL statement

MySQL View database objects (SQL command Summary)