,
for the first query,
select concat(team_id,' (',sum(points),')') from games,points
where games.game_id=points.game_id
and games.team_id1=points.team_id
group by team_id
can solve the problem.
For the second, join players and points.
Mathias
Selon David Legault [EMAIL PROTECTED]:
Hello,
I'm a regular
Hello,
I'm a regular user of MySQL but lately on a personal project I've run
into some very complexe query management and am a little bit confused on
how to get it working. This is a hockey league stats website application.
I have 4 tables with the following columns:
teams - team_id |
You might want to try BigDump
http://www.ozerov.de/bigdump.php
I can't tell how it will cope with 1 GB of data though.
David
Brian Dunning wrote:
I have to load my remote MySQL db's with about a gig of data -
phpMyAdmin only allows me to upload a 15MB CSV file, so I have to
painstakingly
Hello,
I'm using the MySQL C API and I got the following error for this query:
UPDATE tracks SET track_state='-2', track_cost='1.50' WHERE
track_flynum='10' AND track_testcase='45' ORDER BY track_step DESC LIMIT 0,1
SQL Error 1064 : You have an error in your SQL syntax; check the manual