Re: Re: (OT) MySQL select Question

in reply to Re: (OT) MySQL select Question
in thread (OT) MySQL select Question

mysql doesn't do subqueries yet... You better do 2 selects and insert the data from the first into the second one.

Greetz
Beatnik
... I'm belgian but I don't play one on TV.

Comment on Re: Re: (OT) MySQL select Question

Replies are listed 'Best First'.
Re: Re: Re: (OT) MySQL select Question by antirice (Priest) on Jul 26, 2003 at 22:36 UTC
Umm... I know MySQL doesn't do subselects. In the selection I posted, there aren't any subselections. The module of which I was speaking was so you could actually use SQL-92 style subselections but have them translated into multiple queries which, yes, do create temporary tables. For this particular query, however, there is no need to create a second table. Updated: Seemed a bit harsh. Just having a bad day :-/ antirice The first rule of Perl club is - use Perl The ith rule of Perl club is - follow rule i - 1 for i > 1	[reply]

Replies are listed 'Best First'.

Re: Re: Re: (OT) MySQL select Question
by antirice (Priest) on Jul 26, 2003 at 22:36 UTC

Umm... I know MySQL doesn't do subselects. In the selection I posted, there aren't any subselections. The module of which I was speaking was so you could actually use SQL-92 style subselections but have them translated into multiple queries which, yes, do create temporary tables. For this particular query, however, there is no need to create a second table.

Updated: Seemed a bit harsh. Just having a bad day :-/

antirice
The first rule of Perl club is - use Perl
The ith rule of Perl club is - follow rule i - 1 for i > 1

[reply]

In Section Seekers of Perl Wisdom