直接码sql:
room
字段值为 18F-N01
这种格式
UPDATE t_report SET room = CONCAT_WS( '-', SUBSTRING_INDEX(room, '-', 1) ,
CASE SUBSTRING_INDEX(room, '-', -1)
WHEN 'N01' THEN 'N02'
WHEN 'N02' THEN 'N01'
WHEN 'N03' THEN 'N11'
WHEN 'N04' THEN 'N10'
WHEN 'N05' THEN 'N09'
WHEN 'N06' THEN 'N08'
WHEN 'N07' THEN 'N07'
WHEN 'N08' THEN 'N06'
WHEN 'N09' THEN 'N05'
WHEN 'N10' THEN 'N03'
END )
WHERE rid IN (
SELECT rid FROM t_report WHERE rdate = '190306' AND ordinal BETWEEN '23' AND '32'
)