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

mysql 导数据 为excel

标签：