首选声明一点,遇到此类需求,首选的肯定是用存储过程,不过今天同事就是说不想用存储过程,所以再想到这最粗暴的做法。
数据库表数据:
目的:
用一条sql语句 实现imageid为8和9的两条数据中image_num值得互换
update sys_image set image_num = (case when image_id = 8 then (select image_num from sys_image where image_id = 9) when image_id = 9 then (select image_num from sys_image where image_id = 8) end) where image_id in (8,9)