方法一:update hotel_reason set agent_id=(@temp:=agent_id),agent_id=type,type=@temp
方法二:
update hotel_reason as a,hotel_reason as b
set a.agent_id=b.type,a.type=b.agent_id
where a.id=b.id
复制一个表的字段到另一个表的字段上
UPDATE hotel_order_detail d INNER JOIN hotel_order_child dc
ON d.order_id = dc.order_id
SET dc.order_id_plt = d.parent_order_id_plt