Hi Laszlo,
This is sort of a butchery, and might be a little nicer with two queries
and a temp table, but this works in mysql 4.1.3-beta (at least, it did
for me).
SELECT A.name, B.proj
FROM people as A, project as B
WHERE A.rsrc=B.rsrc
GROUP BY A.name, B.proj
HAVING COUNT(*)=(SELECT COUNT(*)
Hi all. Just a quick syntax question. Is there a way to select rows
from a different server database into the one currently in use? In
other words, if I had two servers, is there something equivalent to
saying (while using the client on server1):
SELECT * FROM
|
+---+--+++-++--+-+
Thanks so much!
-Matt
-Original Message-
From: [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 14, 2004 3:46 AM
To: Matt Eaton
Subject: Re: GROUP
Hi all. Got a weird one. Mysql 4.0.20. Let's say for the sake of
argument that I've got two tables, T1 T2. Here are the two create
statements:
CREATE TABLE `T1` (
`guid` smallint(5) unsigned NOT NULL default '0',
`qid` smallint(5) unsigned NOT NULL default '0',
`a` tinyint(2) NOT NULL
Hey Rob,
You're looking for a group by to allow mysql to aggregate over the IP's:
SELECT ip, count(*) FROM iptable GROUP BY ip ORDER BY ip DESC limit 10;
-Matt
-Original Message-
From: rmck [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 1:03 PM
To: [EMAIL PROTECTED]
Subject:
Woops! Forget I said that, you wanted to order by the most occurrences.
Sorry.
SELECT ip, count(*) FROM iptable GROUP BY ip ORDER BY 2 DESC limit 10;
Heh... I should learn to read one of these days...
-Matt
-Original Message-
From: rmck [mailto:[EMAIL PROTECTED]
Sent: Thursday, July
Hi all,
I was hoping this was the right place for a question about the C API.
I've been grabbing result sets from tables in the C API for a few years
now, but I'm starting to work with result sets that are big enough to
bog me down. Of course, the result sets aren't insanely big, so I was