Posted on 2011-04-08 19:42
追梦人 阅读(210)
评论(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