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