mysql 表名和字段、备注
时间：2021-07-01 10:21:17
帮助过：74人阅读
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
;
mysql 表名和字段、备注
标签：osi and max column db_name view font nbsp div
