mysql语句荟萃

1.多表查询
从表t2中查询id ，更新表t1中对相应的id。

update tbl_members t1, tbl_playerinfo t2 set t1.id=t2.id where t1.role_name=t2.playername ;

2.关于批量删除表中数据

delete FROM player WHERE playerid=1 AND type=0 order by id asc limit 3;

满足一定条件,并按id升序删除表uw_play的前3条记录。
3.排名的获取

在tbl_paihang表中,获取roleid = 222的wealth排名

SELECT count(*)+1 FROM tbl_paihang as a ,tbl_paihang AS b where a.wealth>b.wealth AND b.roleid = 222 ;