MySQL Query statement

Query Library The file size of the table below has MySQL library as an example
Select
TABLE_NAME,
Concat (Truncate (data_length/1024/1024,2), ' MB ') as Data_size,
Concat (Truncate (index_length/1024/1024,2), ' MB ') as Index_size
From Information_schema.tables
where table_schema = ' MySQL '
GROUP BY TABLE_NAME
ORDER BY data_length Desc;

Statistics MySQL duplicate data already name field for example
Select Name, count () as Count from Zipkin_spans Group by name have Count >1;
Count the total number of MySQL table data
Select COUNT () from Zipkin_spans;

MySQL Query statement