.image_id' at line 1
Anyone see where I am going wrong?
Thank you.
Gary
__ Information from ESET Smart Security, version of virus
signature database 5063 (20100426) __
The message was checked by ESET Smart Security.
http://www.eset.com
__ Informatio
I want to select all the rows where the minimum
of column1 and column2 are bigger than the maximum of col3 and col4
... WHERE Least(col1,col2) > Greatest(col3, col4) ...
PB
http://www.artfulsoftware.com
-
Peng Yu wrote:
I don't see there is a function to compute min or max of two numbers
your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'keywords AS kw
> USING (image_id)WHERE ky.image_id = im.image_id' at line 1
>
> Anyone see where I am going wrong?
>
> Thank you.
>
> Gary
&g
rong?
>
> Thank you.
>
> Gary
>
>
>
> __ Information from ESET Smart Security, version of virus signature
> database 5063 (20100426) __
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
im.image_id' at line 1
Anyone see where I am going wrong?
Thank you.
Gary
__ Information from ESET Smart Security, version of virus signature
database 5063 (20100426) __
The message was checked by ESET Smart Security.
http://www.eset.com
--
MySQL General Mail
On Tue, 27 Apr 2010 09:08:29 Peng Yu wrote:
> I don't see there is a function to compute min or max of two numbers
> in a row. Essentially I want to select all the rows where the minimum
> of column1 and column2 are bigger than the maximum of col3 and col4
> (The following code won't work as I expe
I don't see there is a function to compute min or max of two numbers
in a row. Essentially I want to select all the rows where the minimum
of column1 and column2 are bigger than the maximum of col3 and col4
(The following code won't work as I expected, if I am correct).
select * from a_table where
Yves,
What happens if you replace the "tk.UserId IN (22943, 10899)" with
just one argument " tk.UserId = 22943".
Does it run much faster? If so, the In() statement may not be using an
index. You could try using a Union instead of In() to see if that is any
faster.
I have also found tha
Hi,
You probably aren't doing anything wrong, per se, but I suspect
Handler::info() is slow and is being called once per partition. You
should probably start looking at your system overall to check where
the time is spent. Is it in reading from disk? If so, can you make
it read from memory inst
Hi!
Zardosht Kasheff wrote:
> Hello all,
>
> What is the difference between 5.5.4 and 5.5.3? I see that 5.5.3 is
> available on more platforms. Is one more stable than the other?
MySQL 5.5.3 and 5.5.4 were announced in one common mail on this list,
and that mail also tells what is different in
We have installed mysql-5.1.39 and having a database with following table.
CREATE TABLE `EntMsgLog` (
`msgId` bigint(20) NOT NULL,
`causeId` bigint(20) NOT NULL,
`entityId` int(11) NOT NULL,
`msgReceiver` bigint(20) NOT NULL,
`msgTextId` int(11) NOT NULL,
`flags` bit(8) NOT NULL,
`t
11 matches
Mail list logo