mysql 自定义固定值字段
SELECT msgId,msgType,msgContent,"message" as noticeOrMessage from finance_message_remind UNION select noticeId,noticeType,noticeContent,"notice" as noticeOrMessage from finance_system_notice
SELECT msgId,msgType,msgContent,"message" as noticeOrMessage from finance_message_remind UNION select noticeId,noticeType,noticeContent,"notice" as noticeOrMessage from finance_system_notice