mysql 读取表字段注释 

                                select TABLE_NAME TableName
                                    ,COLUMN_NAME FieldName
                                    ,DATA_TYPE FieldTypeName
                                    ,0 FieldMaxLength
                                    ,COLUMN_COMMENT FieldDesc
                                from information_schema.COLUMNS 
                                where table_name = 'person'

 

posted @ 2022-05-18 21:51  温故纳新  阅读(104)  评论(0)  编辑  收藏  举报