Hi.
On Thu 2002-07-11 at 09:53:05 -0400, [EMAIL PROTECTED] wrote:
> Bhavin,
>
> I am using distinct all 15 fields and order by all 15 fields, but there is
> different order on 15 fields for distinct and order by.
Are all fields of binary types? If not, DISTINCT equals "sort -uf", not
"sort -u" (i.e. ignore case) for those columns.
Greetings,
Benjamin.
[...]
> >> I have a 76,500,000 rows table with 15 fields.
> >> I try to sort this rows on all fields, so I am using select all fields1
> >> group by all fields2 or distinct all fields1 with order by all fields2.
> >> After sort, I get 62,000,000 rows.
> >>
> >> Then I use Linux unique sort, I dump out 76,500,000 table and using
> >sort -u
> >> file1 -o file2.
> >> I got 76,000,000 rows.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
