.
Regards,
Gavin Towey
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Thursday, August 19, 2010 10:07 AM
To: [MySQL]
Subject: Re: Fixture List generation using MySQL
I'm looking at a routine / script to create the fixtures like
team 1 vs team 2
team
... itchy
trigger finger.
- Original Message - From: Gavin Towey gto...@ffn.com
To: Tompkins Neil neil.tompk...@googlemail.com; [MySQL] mysql@lists.mysql.com
Sent: Thursday, August 19, 2010 1:50 PM
Subject: RE: Fixture List generation using MySQL
That's almost a cartesean product
Hi,
I'm tasked with generating a list of fixtures from a table of teams, whereby
each team plays each other home and away. Does anyone have any experience
generating such information using MySQL ?
Thanks for any input.
Regards
Neil
I'm tasked with generating a list of fixtures from a table of teams, whereby
each team plays each other home and away. Does anyone have any experience
generating such information using MySQL ?
Basically ...
select a.id,b.id from tbl a join tbl b on a.idb.id;
union
select a.id,b.id from tbl
I'm looking at a routine / script to create the fixtures like
team 1 vs team 2
team 3 vs team 4
team 5 vs team 6 etc
On Thu, Aug 19, 2010 at 3:44 PM, Peter Brawley
peter.braw...@earthlink.net wrote:
I'm tasked with generating a list of fixtures from a table of teams,
whereby
each
I'm looking at a routine / script to create the fixtures like
team 1 vs team 2
team 3 vs team 4
team 5 vs team 6 etc
Build the script round the query.
PB
-
On 8/19/2010 12:07 PM, Tompkins Neil wrote:
I'm looking at a routine / script to create the fixtures like
team 1 vs team 2
team.
Regards,
Gavin Towey
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Thursday, August 19, 2010 10:07 AM
To: [MySQL]
Subject: Re: Fixture List generation using MySQL
I'm looking at a routine / script to create the fixtures like
team 1 vs team 2
generation using MySQL
I'm looking at a routine / script to create the fixtures like
team 1 vs team 2
team 3 vs team 4
team 5 vs team 6 etc
Build the script round the query.
PB
-
On 8/19/2010 12:07 PM, Tompkins Neil wrote:
I'm looking at a routine / script to create the fixtures like
team 1
...@googlemail.com; [MySQL]
mysql@lists.mysql.com
Sent: Thursday, August 19, 2010 1:50 PM
Subject: RE: Fixture List generation using MySQL
That's almost a cartesean product; except you just want to eliminate results
where a team would be paired up with itself.
create table teams ( id serial