MySQL查看表结构

查看表结构

SELECT 
    *
FROM
    information_schema.tables
WHERE
    table_schema = 'db_name'
        AND table_name = 'table_name'

查看字段

SELECT 
    *
FROM
    information_schema.columns
WHERE
    table_schema = 'db_name'
        AND table_name = 'table_name'

查看表的大小和行数

SELECT 
    TABLE_NAME,
    TABLE_ROWS,
    DATA_LENGTH / 1024 / 1024 AS DATA_LENGTH,
    CREATE_TIME,
    TABLE_COLLATION
FROM
    INFORMATION_SCHEMA.TABLES
WHERE
    TABLE_SCHEMA = 'db_name'
ORDER BY TABLE_ROWS DESC