On Sat, 16 Nov 2002 12:40:51 -0000
"Jocelyn Fournier" <joc@stripped> wrote:
> Well, I'm inserting :
>
> INSERT INTO threadhardwarefr7 VALUES (1,1),(1,2);
>
> And the subselect is done on the same table :
>
> mysql> SELECT numreponse FROM threadhardwarefr7 WHERE numeropost='1'
> -> AND numreponse=(SELECT MAX(numreponse) FROM threadhardwarefr7
> WHERE-> numeropost='1');
> +------------+
> | numreponse |
> +------------+
> | 2 |
> +------------+
> 1 row in set (0.02 sec)
>
> Regards,
> Jocelyn
>
I think that this issue is well explained with HASH versus BTREE...
--
Regards,
--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sinisa@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
