Posted on 2011-04-08 19:42
追夢人 閱讀(219)
評論(0) 編輯 收藏 所屬分類:
mysql
delete c.* from drolecontest c left join drolebase d on d.rolebaseid=c.rolebaseid where d.rolelevel<16
update drolecontest c left join drolebase d on d.rolebaseid=c.rolebaseid set c.ranking=0,c.affluence=0 where d.rolelevel<=15