From: Rob Wultsch (wultschgmail.com)
Date: Tue Oct 21 2008 - 00:42:10 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Mon, Oct 20, 2008 at 9:31 PM, Rob Wultsch <wultschgmail.com> wrote:

> On Mon, Oct 20, 2008 at 8:30 PM, Perrin Harkins <perrinelem.com> wrote:
>
>> On Mon, Oct 20, 2008 at 10:15 PM, Sangeetha <ysndargmail.com> wrote:
>> > Gosh I wonder
>> > why mysql does not support SEubqueries.. It just hangs in the copying to
>> tmp
>> > table status. Atleast I know whats wrong... Thanks very much
>>
>> It supports them, but won't optimize them well until 5.2. There's
>> some good info here:
>>
>> http://www.xaprb.com/blog/2006/04/30/how-to-optimize-subqueries-and-joins-in-mysql/
>>
>> - Perrin
>>
>
> I'm pretty sure 5.2 became 6.0
> 6.0 is two major versions out
> The last major release happened 3 years ago
>

What I should have said is:

five two is six oh
five one comes before six oh
five oh three years old

--
Rob Wultsch

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]