Home  >  Article  >  Database  >  获取表结构中注释信息的语句_MySQL

获取表结构中注释信息的语句_MySQL

WBOY
WBOYOriginal
2016-06-01 13:42:411216browse

bitsCN.com
获取表结构中注释信息的语句 MYSQL: 获取表注释: 1SELECT table_name  表名,TABLE_COMMENT 表注释 FROM INFORMATION_SCHEMA.TABLES  WHERE table_schema = 'yikang' ##数据库名2AND table_name LIKE 'food'##表名
 获取字段注释:     1SELECT COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释2FROM INFORMATION_SCHEMA.COLUMNS3WHERE table_name = 'food'##表名4AND table_schema = 'yikang'##数据库名5AND column_name = 'name'##字段名   作者 黑豆白 bitsCN.com

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