query runs for 5 min... kill query id.
On 12 May 2005 00:29:56 +0200, Harald Fuchs <[EMAIL PROTECTED]> wrote:
> In article <[EMAIL PROTECTED]>,
> Eric Jensen <[EMAIL PROTECTED]> writes:
>
> > So you want 5 contacts for every user? Try this:
> > SELECT COUNT(c.id) AS count, u.username, u.firs
In article <[EMAIL PROTECTED]>,
Eric Jensen <[EMAIL PROTECTED]> writes:
> So you want 5 contacts for every user? Try this:
> SELECT COUNT(c.id) AS count, u.username, u.first_name, u.last_name,
> c.name
> FROM user AS u, contact AS c
> WHERE u.id = c.id_user
> GROUP BY c.id_user
> HAVING count
So you want 5 contacts for every user? Try this:
SELECT COUNT(c.id) AS count, u.username, u.first_name, u.last_name,
c.name
FROM user AS u, contact AS c
WHERE u.id = c.id_user
GROUP BY c.id_user
HAVING count <= 5
Jerry Swanson wrote:
>How to select 5 records(including username, first_name, l
I need 5 records per user.
On 5/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hi,
> try this,
>
> select username, first_name,last_name, name as contact
> from user,contact
> where user.id=contact.user_id
> order by username;
>
> Mathias
>
> Selon Jerry Swanson <[EMAIL PROTECTED]>:
>
>
Hi,
try this,
select username, first_name,last_name, name as contact
from user,contact
where user.id=contact.user_id
order by username;
Mathias
Selon Jerry Swanson <[EMAIL PROTECTED]>:
> How to select 5 records(including username, first_name, last_name,
> contact) for each user in the database
How to select 5 records(including username, first_name, last_name,
contact) for each user in the database?
table user(
id,
username,
first_name,
last_name
)
contact(
id
id_user //id from user table
name
)
--
MySQL General Mailing List
For