记一个小知识 检索一张表的字段属性和注释 SELECT COLUMN_NAME, COLUMN_COMMENT FROM information_schema.`COLUMNS` WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'table_name' 检索所有信息 SELECT * FROM information_schema.`COLUMNS` WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'table_name'