SV: index troubles

2001-04-30 Thread Wix,Christian XCW
But why doesn't this work then: select name, tottid, distance, min(mintid) from loeb group by distance; (tottid seems to be random) mysql explain select name, tottid, distance, min(mintid) from loeb group by distance; +---+--+---+--+-+--+--+---+ |

Re: SV: index troubles

2001-04-30 Thread Thalis A. Kalfigopoulos
On Mon, 30 Apr 2001, Wix,Christian XCW wrote: But why doesn't this work then: select name, tottid, distance, min(mintid) from loeb group by distance; (tottid seems to be random) mysql explain select name, tottid, distance, min(mintid) from loeb group by distance;