查看获取表内字段注释:
1 2 3 4 5 6 7 8 9 10 11 |
show full columns from tablename; 或是 show full fields from tablename; 或是,在元数据的表里面看 Select COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释 from INFORMATION_SCHEMA.COLUMNS Where table_name = 'companies' ##表名 AND table_schema = 'testhuicard' ##数据库名 AND column_name LIKE 'c_name' ##字段名 |