On Jan 10, 2008 5:40 PM, Eben <[EMAIL PROTECTED]> wrote:
> I want to be able to do count of the total records brought back by this
> query... but since I am using the group by I can't use COUNT() in the
> desired way.
Assuming what you want is all the data from your current query plus an
additiona
what ever happend to a unique primary key like userID ?
>>> "gord barq" <[EMAIL PROTECTED]> 08/11/03 11:15am >>>
I have a table I'm using for logging purposes with a schema like:
create table results (
user varchar(255)
);
Where user is not a unique field and I want to find out how
select count(distinct(user)) from results;
Cheers,
Jan
--
Janice Wright
Ingenta plc
[EMAIL PROTECTED]
Tel: +44 (0) 01865 799114
http://www.ingentaselect.com/
Sometime recently Daniel Rossi said:
> what ever happend to a unique primary key like userID ?
>
> >>> "gord barq" <[EMAIL PROTECTED
On Mon, 11 Aug 2003, gord barq wrote:
> I have a table I'm using for logging purposes with a schema like:
>
> create table results (
> user varchar(255)
>
> );
>
> Where user is not a unique field and I want to find out how many unique
> users there are in the table.
>
> I want to do
>
> what ever happend to a unique primary key like userID ?
>
User is not the primary key. This is a logging table so the primary key is
likely to be a timestamp of some sort.
Read the question.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
At 08:15 PM 8/10/2003, you wrote:
I have a table I'm using for logging purposes with a schema like:
create table results (
user varchar(255)
);
Where user is not a unique field and I want to find out how many unique
users there are in the table.
I want to do something like:
select co