获取表结构中注释信息的语句_MySQL
- 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
Previous article：mysql中字符串或字段中空格函数的删除_MySQLNext article：mysql客户端(Navicat)远程登录操作再遇问题1142-create command_MySQL