Hi,
Is something wrong with a sql query like this?
(SELECT commentname, count(comments.ID) as comid, 'comments' as section from
comments where commentname IN (SELECT DISTINCT commentname from comments
where id=35037 ORDER BY commentname)Group by commentname) UNION ALL (SELECT
Username, count(ID),
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,
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
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
some
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... Thanks very
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 hangs in the