mysql 导数据 为excel

SELECT
    b.dealerName as 经销商名称,
  c.comName as 品牌商名称,
  FROM_UNIXTIME(a.clearingTime/1000 ,'%y-%m-%d')as 付款时间,
  a.clearingAmount as 结算金额,
  CAST(a.clearingStatus AS signed) as 支付状态(0未支付,1支付)
FROM
    DealerClearing a,
    DealerInfo b,
    BrandInfo c
WHERE
    a.brandId = c.brandId
AND a.dealerId = b.refrenceId
order by 付款时间 desc

posted on 2015-07-14 17:10  丿易小易  阅读(98)  评论(0编辑  收藏  举报

导航