On Sat, Apr 20, 2002 at 05:16:46AM +0200, Benjamin Pflugmann wrote:
Hi.
[...]
According to the MySQL doc (5.2.7, example 5) this should work
using the index without any additional sorting.
MySQL-3.23.49-max-log running on FreeBSD 4.4-RELEASE
I assume you are referring to the
Hello.
On Sun, Apr 21, 2002 at 02:15:33PM +0200, [EMAIL PROTECTED] wrote:
[...]
I assume you are referring to the online manual? It's documenting the
most recent version. According to the change history (Appendix D),
this optimization was introduced in version 4.0.2.
I see, thanks for
Hi benjamin/Sven,
it's my understanding that the latest revision of the manual is (minus
4.x commits) always included in the distribution set. New features
are always documented in the manual and are nearly always appended
with a This was added in version insert version here string some
place.
On Sunday, 21. April 2002 20:54, Colin Faber wrote:
it's my understanding that the latest revision of the manual is (minus
4.x commits) always included in the distribution set. New features
are always documented in the manual and are nearly always appended
with a This was added in version
Hi.
On Fri, Apr 12, 2002 at 02:49:03PM +0200, [EMAIL PROTECTED] wrote:
[...]
mysql explain select * from news where category = 'x' order by category DESC,
provider_date DESC;
Hi there,
please check below
my table:
CREATE TABLE `news` (
`news_id` int(11) NOT NULL auto_increment,
`provider_id` int(11) NOT NULL default '0',
`provider_news_id` char(50) default NULL,
`category` char(50) NOT NULL default '',
`heading` char(50) NOT NULL default '',