You could also pre-define your intervals in a subquery using UNION and join
that to your original table like so:
select ifnull(sum(calls), 0) as calls, n as queue_seconds
from
(select 0 as n union
select 5 union
select 10 union
select 15) as step
left join calls on calls.queue_seconds > (ste
Hi, All,
Regarding mysql, I have problems on concurrent updates in the following
settings. I get a mysql server containing one database with 512 tables.
There is also a client who send concurrent updates to the server, each
update by a thread. As I increase the number of concurrent updates, I have
Hi all,
Aveeks solution should work if you have at least one call for each intervall.
It's the classical GROUP BY solution that only works on the available dataset.
Although it should work pretty well in the cited scenario, you will miss
intervals (from a "all intervals report" point of view) if i
sorry I went to sleep CEST here,
its created by default by MySQL
Cheers!
Claudio
On 8/1/2010 2:15 AM, Corey wrote:
On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote:
login as root and remove 'empty' user ,issue:
delete from mysql.user where user='';
flush privileges;
mysql authenti
sorry I went to sleep CEST here,
its created by default by MySQL
Cheers!
Claudio
On 8/1/2010 2:15 AM, Corey wrote:
On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote:
login as root and remove 'empty' user ,issue:
delete from mysql.user where user='';
flush privileges;
mysql authenti
