On Mon, Oct 20, 2008 at 9:31 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> On Mon, Oct 20, 2008 at 8:30 PM, Perrin Harkins <[EMAIL PROTECTED]> wrote:
>
>> On Mon, Oct 20, 2008 at 10:15 PM, Sangeetha <[EMAIL PROTECTED]> wrote:
>> > Gosh I wonder
>> > why mysql does not support SEubqueries.. It just
On Mon, Oct 20, 2008 at 8:30 PM, Perrin Harkins <[EMAIL PROTECTED]> wrote:
> On Mon, Oct 20, 2008 at 10:15 PM, Sangeetha <[EMAIL PROTECTED]> 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... T
On Mon, Oct 20, 2008 at 10:15 PM, Sangeetha <[EMAIL PROTECTED]> 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
so
Thanks so much Rob, I will try and use joins and avoid Selects within
Selects ...I tried to comment out this select and it works... 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
On Mon, Oct 20
1, Subqueries should be avoid when using mysql. Rewriting to be using joins
will probably solve your problem.
2. Explain is your friend.
On Mon, Oct 20, 2008 at 4:38 PM, Sangeetha <[EMAIL PROTECTED]> wrote:
> Hi,
> Is something wrong with a sql query like this?
> (SELECT commentname, count(commen
