SELECT `COLUMN_NAME`,`COLUMN_COMMENT` FROM `COLUMNS` WHERE `TABLE_SCHEMA` = 'zhuohun' AND `TABLE_NAME` = 'user_life' LIMIT 0 , 30 MYSQL5+查询表结构名称加备注信息