Posted on 2010-02-10 10:30
追夢(mèng)人 閱讀(177)
評(píng)論(0) 編輯 收藏 所屬分類:
mysql
update dotarank as dr left join ((select * from dotarank where `type`=2) as d) on dr.name=d.name set dr.assistschange=dr.assists-d.assists where dr.`type`=3;
mysql關(guān)鍵字用tab上面那個(gè)符號(hào)排除