mysql查询增加表头

select '微信支付流水号' as juan_orderno
		,'捐赠人'
		,'手机号码'
		,'捐赠金额'
		,'捐赠时间'
		,'捐赠项目'
		,'捐赠人备注'
)
union all
(
	select juan_orderno
		,juan_name
		,juan_phone
		,juan_price
		,juan_addtime
		,case_name
		,juan_remark
	from `juan`
	join `case` on juan_case_id=case_id
	where juan_status=1
)
order by juan_orderno desc

posted on 2022-09-09 11:05  小馬過河﹎  阅读(41)  评论(0)    收藏  举报

导航