List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 20 1999 12:19am
Subject:Re: Unique Records
View as plain text  
At 11:15 PM +0000 6/19/1999, Sean McKenna wrote:
>On Sat, 19 Jun 1999 15:48:46 -0500, you wrote:
>
>>>I had not seen DISTINCTROW before, I always use DISTINCT.
>>>
>>>DISTINCTROW does not work for me, but DISTINCT does just fine.
>>
>>
>>DISTINCTROW seems to have been added between MySQL 3.21 and 3.22.
>
>That explains it since I am running 3.21.  In the 3.22 documentation
>online I find DISTINCTROW listed in the reserved words (which is new
>to the documentation since 3.21) but there is no reference to it
>elsewhere.  Does it do something different than DISTINCT or is it a
>synonym?

sql/ChangeLog contains this note:

Mon May  4 00:33:27 1998  Michael Widenius  <monty@stripped>

* Added BOOL as a synonym for BIT and DISTINCTROW as a synonym for DISTINCT.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
Unique Recordstoxalot19 Jun
Re: Unique RecordsKevin Smith19 Jun
Re: Unique Records(Sean McKenna)19 Jun
  • Re: Unique RecordsPaul DuBois20 Jun
    • Re: Unique Records(Sean McKenna)20 Jun
      • Re: Unique RecordsPaul DuBois20 Jun