[MySQL] 获取基础信息

select * from information_schema.tables;

SELECT
    table_schema,
    SUM((data_length + index_length) / 1024 / 1024) AS MB
FROM
    information_schema.tables
GROUP BY 1;

SELECT
    table_schema,
    SUM((data_length + index_length) / 1024 / 1024) AS MB
FROM
    information_schema.tables
WHERE
    table_schema = 'This is your database name'
GROUP BY table_schema;

SELECT
    COUNT(*)
FROM
    information_schema.tables
WHERE
    table_schema = 'This is your database name';

SELECT
    table_schema,
    table_name,
    (data_length + index_length) / 1024 / 1024 AS MB
FROM
    information_schema.tables
WHERE
    table_schema = 'This is your database name';