今天业务需求中需要用到UNION,SQL如下:
select p.id as id, p.`column` as `column`, p.`value` as `value`, p.history_begin_time as history_begin_time, p.history_end_time as history_end_time
from cmdbcoresvrdb.p_fixednetworkelement p
WHERE p.id = 0x11E8A2BD695CD4C692DB286ED288C859