mysql备份表+表头

select 'tml_id','retailer_name'（表头） union all
(select 'tml_id','retailer_name' from tml_base
 into outfile 'd:\data.xls');