Home  >  Article  >  Database  >  Mysql 查询列注释及列名称_MySQL

Mysql 查询列注释及列名称_MySQL

WBOY
WBOYOriginal
2016-06-01 13:51:56933browse

//查询列注释及列名称
Mysql 查询列注释及列名称_MySQLselect  column_name, column_comment from information_schema.columns where table_schema ='databaseName'  and table_name = 'tableName';//查询表注释及表名称
Mysql 查询列注释及列名称_MySQLselect table_name,table_comment from information_schema.tables  where table_schema = 'image' and table_name ='tableName';

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn