I have two mysql instances in my mysql cluster. I noticed that their
MysSQL.user tables do not have the same number of columns. Their USER table
attributes are not the same. One instance has 39 columns while the other has 42
columns. Can someone please help me here. Could it be because I'm runni
;>>> 2012/03/19 12:06 -0400, Steven Staples
SELECT `user_id`, GROUP_CONCAT(DISTINCT `login_ip`) AS 'login_ips',
COUNT(`id`) AS 'connections'
FROM `mysql_test`
WHERE `login_datetime` BETWEEN '2012-03-19 00:00:00' AND '2012-03-19
23:59:59'
GROUP BY `user_id`
HAVING COUNT(`id`) > 2
ORDER BY COUNT
> -Original Message-
> From: Mihail Manolov [mailto:mihail.mano...@liquidation.com]
> Sent: March 19, 2012 12:44 PM
> To: Steven Staples
> Cc:
> Subject: Re: Group_Concat help...
>
> Try this
>
> SELECT `user_id`, `login_ip`,
> COUNT(`id`) AS 'connections'
> FROM `mysql_test`
> WHERE `lo
Try this
SELECT `user_id`, `login_ip`,
COUNT(`id`) AS 'connections'
FROM `mysql_test`
WHERE `login_datetime` BETWEEN '2012-03-19 00:00:00' AND '2012-03-19
23:59:59'
GROUP BY `user_id`, `login_ip`
HAVING COUNT(`id`) > 2
ORDER BY COUNT(`id`) DESC
LIMIT 0, 15;
On Mar 19, 2012, at 12:06 PM, Steven S
Hello!
I am trying to do something, but I can't seem to figure out how...
My query is as follows:
SELECT `user_id`, GROUP_CONCAT(DISTINCT `login_ip`) AS 'login_ips',
COUNT(`id`) AS 'connections'
FROM `mysql_test`
WHERE `login_datetime` BETWEEN '2012-03-19 00:00:00' AND '2012-03-19
23:59:59'
GROUP
- Original Message -
> From: "Charles Brown"
>
> I have two mysql instances in my mysql cluster. I noticed that their
> MysSQL.user tables do not have the same number of columns. Their
> USER table attributes are not the same. One instance has 39 columns
> while the other has 42 columns.
