Hi.
On Fri 2002-07-26 at 11:00:31 -0400, [EMAIL PROTECTED] wrote:
> >
> >Hi Benjamin, Arjen
> >
> >I did some testing again. I have 75,000,000 rows table, after using group
> >by I got 62,300,000 rows.
> >If I use *nix -u sort, I got 74800,00 rows.
> >
> >I compared the two results, I feel I tru
>
>Hi Benjamin, Arjen
>
>I did some testing again. I have 75,000,000 rows table, after using group
>by I got 62,300,000 rows.
>If I use *nix -u sort, I got 74800,00 rows.
>
>I compared the two results, I feel I trust my *nix result. Some lines just
>miss in "group by' result, look like no reaso
Hi Benjamin, Vivian,
On Wed, 2002-07-24 at 05:23, Benjamin Pflugmann wrote:
> On Tue 2002-07-23 at 14:58:16 -0400, [EMAIL PROTECTED] wrote:
> > 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
> >
Hi.
On Tue 2002-07-23 at 14:58:16 -0400, [EMAIL PROTECTED] wrote:
> 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 optio
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
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"
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.
Thanks
At 08:24 PM 7/10/2002 -0700, Bhavin Vyas wrote:
>Via mysql, you are trying to do a distinct 'field1'. So any field1
>duplicates will be removed. Wher
Via mysql, you are trying to do a distinct 'field1'. So any field1
duplicates will be removed. Where as in the Linux sort only entire row
duplicates will be removed meaning 'field1field2'. They would return the
same number of records only if you selected field1 only and then sorted it
via the