I'm running MySql 4.0.10-gamma-max-nt-log
I have 1 table like the one below...
++-+--+
| DAY| USERID | LIS_QUANTITY |
++-+--+
| 2003-01-02 | H0850A1 | 539 |
| 2003-01-02 | LBBSWJR |7 |
| 2003-01-02 |
: Paul, do you address this in any of your books?
I'm running MySql 4.0.10-gamma-max-nt-log
I have 1 table like the one below...
++-+--+
| DAY| USERID | LIS_QUANTITY |
++-+--+
| 2003-01-02 | H0850A1 | 539 |
| 2003-01
: Re: Paul, do you address this in any of your books?
Hi,
You can try to use IF(),CASE() function in the SQL statement.
Eg.
select USERID,IF(DAY='2003-01-02',COUNT(*),0) as
2003-01-02,IF(DAY='2003-01-03',COUNT(*),0) as
2003-01-03...how_many_days_you_wishfrom YOUR_TABLES where
At 14:40 -0600 3/14/03, DANIEL GADDIS wrote:
I'm running MySql 4.0.10-gamma-max-nt-log
I have 1 table like the one below...
++-+--+
| DAY| USERID | LIS_QUANTITY |
++-+--+
| 2003-01-02 | H0850A1 | 539 |
| 2003-01-02
this article on cross tabulations should help you ...
http://www.mysql.com/articles/wizard/index.html
- hcir
(mysql sql query)
On Friday, Mar 14, 2003, at 11:40 America/Anchorage, DANIEL GADDIS
wrote:
I'm running MySql 4.0.10-gamma-max-nt-log
I have 1 table like the one below...