Paul DuBois [mailto:paul@stripped] writes:
> At 15:18 -0700 8/20/03, Michael S. Fischer wrote:
> >This is trivial to benchmark yourself. Try:
> >
> >BENCHMARK(100000, SELECT yada, yada FROM test WHERE id IN(1,2,3))
> >
> >And compare to
> >
> >BENCHMARK(100000, SELECT yada,yda FROM test WHERE (id =1 or
> id = 2 or
> >id
> >=3))
> >
> >See http://www.mysql.com/doc/en/Miscellaneous_functions.html for
> >documentation on the BENCHMARK command.
>
> BENCHMARK() is a function, not a command. The syntax you
> suggest will not work. It expects an expression as the
> second argument, not a SELECT statement.
>
> That's my understanding, anyway. If you've been able to make
> that work, I'd be interested to see how you did it.
I stand corrected.
--Michael
