mysql 表名和字段、备注

 

 

select
     t1.table_schema
    ,t1.table_name
    ,t2.ordinal_position
    ,t2.column_name
    ,t2.data_type
    ,t2.character_maximum_length
    ,t2.column_type
    ,t2.column_comment
from information_schema.tables t1
left join information_schema.columns t2
    on t1.table_schema = t2.table_schema and t1.table_name = t2.table_name
where t1.table_schema = ‘db_name‘
    and t1.table_type = ‘view‘
    and t1.table_name = ‘v_name‘
order by
     t1.table_schema
    ,t1.table_name
    ,t2.ordinal_position
limit 100
;

select
     column_name
    ,data_type
    ,CHARACTER_MAXIMUM_LENGTH
    ,column_type
    ,column_comment
from information_schema.columns
where TABLE_SCHEMA =‘db_name‘
    and TABLE_NAME = ‘v_name‘
order by ORDINAL_POSITION
;