mysql 表名 字段名,mysql 表名和字段、备注

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