y... itchy
trigger finger.
- Original Message - From: "Gavin Towey"
To: "Tompkins Neil" ; "[MySQL]" >
Sent: Thursday, August 19, 2010 1:50 PM
Subject: RE: Fixture List generation using MySQL
That's almost a cartesean product; except you just w
a condition to prevent those
> rows from showing up:
>
> > select * from teams t1 JOIN teams t2 ON t1.id!=t2.id;
> +++
> | id | id |
> +++
> | 2 | 1 |
> | 3 | 1 |
> | 4 | 1 |
> | 1 | 2 |
> | 3 | 2 |
> | 4 | 2 |
> | 1 | 3 |
&g
quot; ; "[MySQL]"
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 );
Query OK, 0 rows
well as the logic is quite
simple.
Regards,
--
Burhan Khalid
Sent from my BlackBerry® smartphone from Wataniya Telecom
-Original Message-
From: Peter Brawley
Date: Thu, 19 Aug 2010 12:48:18
To:
Reply-To: peter.braw...@earthlink.net
Subject: Re: Fixture List generation using MySQL
>I
in the first column as the "home 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
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
te
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,
>>>
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;
PB
-
On 8/19/2010 9:12 AM
