In the last episode (Aug 31), Renald Buter said:
> On 12:27 Thu 31 Aug , Duncan Hill wrote:
> > On Thursday 31 August 2006 12:21, Renald Buter wrote:
> > > The problem is that a simple 1-table query shows different
> > > answers depending on whether you select 1 or 2 columns.
>
> *blush*
>
> Of course. I see. How stupid.
>
> Thanks and sorry to have bothered you.
In your particular case, mysql probably pulled the values for your
1-column query directly from that column's index (which would be
sorted), and your 2-column query either pulled from a different index
or had to actually read table data.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
