1、mysql查看表字段和字段描述

 

SELECT column_name,
 column_comment  FROM information_schema.columns WHERE table_schema ='hsex_dev_2271'  AND table_name = 'channel_trade_detail';

 结果: