lt;[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 11:55 AM
Subject: Re: Haw to get specific result?
> I think over other problem.
> In the table (shown below) there is another column defined as
timestamp(6).
> Do you think is it possible to ge
| 031214
2 | hub | 031215
3 | hub | 031217
4 | hub | 031218
- Original Message -
From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: "Pawel Filutowski" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, December 15, 2003 1:53 PM
S
Thanks for Joshua and Jay.
The querys is that I expect.
Best regards,
Pawel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[snip]
id | product
0 | switch
1 | switch
2 | hub
3 | hub
4 | hub
5 | wire
6 | wire
7 | wire
8 | wire
9 | wire
.
.
I`m looking for query which give me result as array:
0 - > count of 'switch'
1 - > count of 'hub'
2 - > count of 'wire'
[/snip]
SELECT COUNT(product), product FROM table
Yogi Berra
---
> -Original Message-
> From: Pawel Filutowski [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 15, 2003 7:49 AM
> To: [EMAIL PROTECTED]
> Subject: Haw to get specific result?
>
>
> Hello,
>
> I have table like this:
>
> id | product
>
Hello,
I have table like this:
id | product
0 | switch
1 | switch
2 | hub
3 | hub
4 | hub
5 | wire
6 | wire
7 | wire
8 | wire
9 | wire
.
.
I`m looking for query which give me result as array:
0 - > count of 'switch'
1 - > count of 'hub'
2 - > count of 'wire'
Haw to do it ??
Regard
