SELECT COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释 FROM information_schema.COLUMNS WHERE table_name = '表名' AND table_schema = '数据库';
SELECT COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释 FROM information_schema.COLUMNS WHERE table_name = '表名' AND table_schema = '数据库';
本文标题:数据库字段及描述
本文链接:https://www.haomeiwen.com/subject/crmwertx.html
网友评论