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
>>FROM PROVINCES
>>GROUP BY province
>>ORDER BY province";
>>$sth=$dbh->prepare($statement);
>>$sth->execute;
>>
>
>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: 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