It's just occurred to me that the IN clause is not a constant.
This probably throws out any chance of using an index for group by?
Cheers
-Original Message-
From: Andrew Armstrong [mailto:[EMAIL PROTECTED]
Sent: Sunday, 29 July 2007 1:07 PM
To: mysql@lists.mysql.com
Subject: Using index
Hey Terry,
1) I've tried placing the Count/Distinct bit first - no change. Could you
elaborate on your "bottom up" parsing? I am not aware of this myself (and
have not read this anywhere). Would be interested if you could elaborate or
provide more info.
2) When a GROUP BY is performed, sorting is
Hi,
I have a query at the moment like this:
SELECT SQL_NO_CACHE STRAIGHT_JOIN t1.col1, t1.col2, t2.col1, ...
MAX(t1.col6)...
(
SELECT Count(DISTINCT col1)
FROM table3 t3
WHERE t3.col1 = t1.col1 AND t3.col2 = t1.col2 AND t3.col1 IN
(139903,140244,14058
Hi,
I have the following query:
SELECT c2, c3, c4, Count(DISTINCT c5)
FROM table1
WHERE c1 IN (1, 2, 3...)
GROUP BY c2, c3, c4
order by null
Yet I can only get it at best to show (under extra): Using where, using
filesort.
I have read up on:
http://dev.mysql.com/doc/refman/5.0/
You may want to consider SQLite if you have not seen it already.
http://www.sqlite.org/
- Andrew
-Original Message-
From: Car Toper [mailto:[EMAIL PROTECTED]
Sent: Sunday, 29 July 2007 7:10 AM
To: mysql@lists.mysql.com
Subject: Is MySQL Embedded the solution?
I am starting to do the R&
Mark Leith wrote:
Maxim Veksler wrote:
On 7/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
krishna chandra prajapati wrote:
Hi Everybody,
I am looking for a tool which can moniter mysql and if any thing
goes wrong
with mysql then it can send a mail or alert. It can show the innodb
Hey all, I'm trying to help out a friend of mine who has a database
based on powerbase - which is a really old database, and he said that
the company has long since closed down.
I was trying to see if I there was any way to import the data from
there in to MySQL. He doesn't think there's any way t
I am starting to do the R&D on the next phase of development on my
program and I am looking for a database and I am wondering if MySQL
Embedded is the solution.
The database needs to be embedded from the standpoint that when my
application starts, so does the database, when mine shuts down, so
doe
Maxim Veksler wrote:
On 7/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
krishna chandra prajapati wrote:
Hi Everybody,
I am looking for a tool which can moniter mysql and if any thing goes wrong
with mysql then it can send a mail or alert. It can show the innodb status
and all the
On 7/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> krishna chandra prajapati wrote:
> > Hi Everybody,
> >
> > I am looking for a tool which can moniter mysql and if any thing goes wrong
> > with mysql then it can send a mail or alert. It can show the innodb status
> > and all the complete det
10 matches
Mail list logo
