UPDATE D_YK081115050 SET
网址=CASE WHEN comefrom='启航福大mba论坛'
THEN 'http://www.fzumba.org'
WHEN comefrom='游戏人的家'
THEN 'http://www.gamerhome.net'
WHEN comefrom='广东凯越车友会'
THEN 'http://www.gdcar.net'
END
网址=CASE WHEN comefrom='启航福大mba论坛'
THEN 'http://www.fzumba.org'
WHEN comefrom='游戏人的家'
THEN 'http://www.gamerhome.net'
WHEN comefrom='广东凯越车友会'
THEN 'http://www.gdcar.net'
END
set 网址=tb1.网址
from tb1
where tb1.comefrom=tb.comefrom