作者:xin丶儿_462 | 来源:互联网 | 2018-04-16 14:38
//查询列注释及列名称
select column_name, column_comment from information_schema.columns where table_schema ='databaseName' and table_name = 'tableName';//查询表注释及表名称
select table_name,table_comment from information_schema.tables where table_schema = 'image' and table_name ='tableName';