查看MySQL数据库表名、表注释、字段名称、类型、长度、备注

查看MySQL数据库表名、表注释、字段名称、类型、长度、备注

以下

// SQL
SELECT  
    T1.TABLE_COMMENT 表注释,
    T1.TABLE_ROWS 表数据量,
    T2.TABLE_NAME 表名,
    T2.COLUMN_NAME 字段名,  
    T2.COLUMN_TYPE 数据类型,  
    T2.DATA_TYPE 字段类型,  
    T2.CHARACTER_MAXIMUM_LENGTH 长度,  
    T2.IS_NULLABLE 是否为空,  
    T2.COLUMN_DEFAULT 默认值,  
    T2.COLUMN_COMMENT 字段备注   
FROM 
    INFORMATION_SCHEMA.TABLES T1
LEFT JOIN
    INFORMATION_SCHEMA.COLUMNS T2
ON
    T1.TABLE_NAME = T2.TABLE_NAME
WHERE  
    T1.TABLE_SCHEMA ='db name'
AND 
    T1.TABLE_NAME LIKE 'start_%'
ORDER BY 
    T1.TABLE_NAME;