Re: count distinct support?
Simon Rees <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
On Thursday 10 November 2005 00:48, Dave Dyer wrote: > Current version of dbd-mysql doesn't seem to support COUNT(DISTINCT xx) > support, although current versions of mysql do: It works for me. The only slight difference is I'm using a column alias. e.g: SELECT COUNT( DISTINCT m.id ) AS count FROM mortgage_cases m ... Give that a try. I'm using MySql 4.0.18, DBI 1.41 and DBD-mysql 3.0002 cheers Simon -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Simon Rees | [email protected] | ORA-03113: end-of-file on communication channel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -- MySQL Perl Mailing List For list archives: http://lists.mysql.com/perl To unsubscribe: http://lists.mysql.com/[email protected]