orupdate name set cell_id='45871' where cell_id In ('45872', '45873', '45875')
楼上的这位兄弟可能误会我的意思了!!! 我需要的是将下列的5个语句合在一起,如何写语句???? update base_name set cell_id='45871' where cell_id='45872' update base_name set cell_id='45824' where cell_id='45823' update base_name set cell_id='47888' where cell_id='47887' update base_name set cell_id='47872' where cell_id='47871'update base_name set cell_id='46928' where cell_id='46927'
update base_name set cell_id= CASE cell_id WHEN '45871' THEN '45872' WHEN '45824' THEN '45823' WHEN '47872' THEN '47871' --.... ELSE cell_id END
樓上的兄弟寫反了update base_name set cell_id= (Case cell_id When '45872' Then '45871' When '45823' Then '45824' When '47887' Then '47888' When '47871' Then '47872' When '46927' Then '46928' Else cell_id End)
set cell_id='45871'
where cell_id In ('45872', '45873', '45875')
我需要的是将下列的5个语句合在一起,如何写语句????
update base_name
set cell_id='45871'
where cell_id='45872'
update base_name
set cell_id='45824'
where cell_id='45823'
update base_name
set cell_id='47888'
where cell_id='47887'
update base_name
set cell_id='47872'
where cell_id='47871'update base_name
set cell_id='46928'
where cell_id='46927'
set cell_id=
CASE cell_id WHEN '45871' THEN '45872'
WHEN '45824' THEN '45823'
WHEN '47872' THEN '47871'
--....
ELSE cell_id
END
set cell_id=
(Case cell_id When '45872' Then '45871'
When '45823' Then '45824'
When '47887' Then '47888'
When '47871' Then '47872'
When '46927' Then '46928'
Else cell_id End)