I have 14 fields are chars (like char(8), char(9)), and one field is int(4). All char fields are mixed with upper case letters, numbers(0-9) and sign(like $). Because there is no low case char, I don't have to put -f option for unix sort.
Thanks. At 08:23 PM 7/23/2002 +0200, Benjamin Pflugmann wrote: >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