List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 19 1999 8:48pm
Subject:Re: Unique Records
View as plain text  
At 6:50 PM +0000 6/19/1999, Sean McKenna wrote:
>On Sat, 19 Jun 1999 10:41:37 +0100, you wrote:
>>use DBI;
>>$dbh=DBI->connect("DBI:mysql:$db:$hostname:$port",$username, $password);
>>$statement="SELECT DISTINCTROW province
>>GROUP BY province
>>ORDER BY province";
>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.

Paul DuBois, paul@stripped
Northern League Chronicles:
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