t1.table_schema
,t1.table_name
,t2.ordinal_position
,t2.column_name
,t2.data_type
,t2.character_maximum_length
,t2.column_type
,t2.column_commentfrominformation_schema.tables t1left joininformation_schema.columns t2on t1.table_schema = t2.table_schema and t1.table_name =t2.table_namewhere t1.table_schema = ‘db_name‘
and t1.table_type = ‘view‘
and t1.table_name = ‘v_name‘
order byt1.table_schema
,t1.table_name
,t2.ordinal_position
limit100;selectcolumn_name
,data_type
,CHARACTER_MAXIMUM_LENGTH
,column_type
,column_commentfrominformation_schema.columnswhere TABLE_SCHEMA =‘db_name‘
and TABLE_NAME = ‘v_name‘
order byORDINAL_POSITION
;
mysql 表名和字段、备注
标签:osi and max column db_name view font nbsp div
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:https://www.cnblogs.com/chenzechao/p/11539839.html