update delete left join

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

只有注册用户登录后才能发表评论。


网站导航: