应用状态为1,其他状态为0
<select id="updateStatus" parameterType="java.lang.Long" resultMap="anfangyunStyle">
UPDATE TableNameSET status=(
CASE
WHEN id =#{id} THEN 1
ELSE 0
END
);
</select>
应用状态为1,其他状态为0
<select id="updateStatus" parameterType="java.lang.Long" resultMap="anfangyunStyle">
UPDATE TableName