First step: Open the MYSQL command line first, through the Start menu-Program-mysql-command lines client,1-1:
Figure 1-1
Step two: In the command, enter use information_schema 1-2 as shown:
Figure 1-2
Step three: Look at the size of the specified database and enter the following statement:
Select concat (Round (sum (data_length/1024/1024), 2), ' MB ') as DATA from TABLES where table_schema= ' OfflineCollectiondb2'; where offlineCollectiondb2 is the database name, replace it with the database name you need to query, as shown in 1-3:
Figure 1-3
-------------------------------------------Split Line--------------------------------------------------------------------------- ---------
1. Query the size of all data
Select concat (Round (sum (data_length/1024/1024), 2), ' MB ') as DATA from TABLES2. View the size of the table for the specified database,For example, the database test in a table
Select concat (Round (sum (data_length/1024/1024), 2), ' MB ') as DATA from TABLES where table_schema= ' test ' and Table_nam E= A;
MySQL querying the size of the database