Re: Access denied with mysqladmin

2010-09-25 Thread Ma Xiaoming
Hi, >¶¼ÊÇÖйúÈ˾Í˵ÖÐÎİÉ^_^ Nice to meet you. But I think that this newsgroup is for the people who come from all of the world. So post topics in English is better for anyone who is also interested about this topic, right? >Ã÷Ìì»á¸üºÃ I like this sentence. Õæ¸ßÐËÄÜÔÚÕâÀï¼ûµ½×Ô¼ºÈË¡£Ï£ÍûÒÔºóÄ

Advanced query help

2010-09-25 Thread Tompkins Neil
Hi, I've the following query SELECT teams_id AS teams_id ,SUM(rating) AS total_team_rating FROM (SELECT teams_id ,players_id ,rating ,IF(@team <> teams_id, @row := 1, @row := @row + 1) AS rank ,@team := teams_id FROM ( SELECT players.teams_id ,players.players_id ,players_master.rating FROM player