André Hänsel wrote:
>> -Ursprüngliche Nachricht-
>> Von: Miles Thompson [mailto:[EMAIL PROTECTED]
>> Gesendet: Donnerstag, 3. August 2006 21:56
>> An: mysql@lists.mysql.com
>> Betreff: Re: Query problem
>>
>> At 03:08 PM 8/3/2006, André Hänsel wrote:
>>
>>> I have a table logging downloads
> -Ursprüngliche Nachricht-
> Von: Miles Thompson [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 3. August 2006 21:56
> An: mysql@lists.mysql.com
> Betreff: Re: Query problem
>
> At 03:08 PM 8/3/2006, André Hänsel wrote:
>
> >I have a table logging downloads (time, username, download)
SELECT DISTINCT username, time, download
FROM table
ORDER BY time DESC
GROUP BY username
André Hänsel wrote:
> Hi Dan, hi Obed,
>
> of course I have no specific username, I want the last 5 downloads of each
> distinct username in the table. :)
>
> Regards,
> André
>
>> -Ursprüngliche Nachr
Hi Dan, hi Obed,
of course I have no specific username, I want the last 5 downloads of each
distinct username in the table. :)
Regards,
André
> -Ursprüngliche Nachricht-
> Von: Dan Buettner [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 3. August 2006 20:15
> An: André Hänsel
> Cc: m
Hi Jon,
you can :
DELETE FROM db_test.tbl_dbaddr;
This would delete all data in db_test.tbl_dbaddr by first dropping the
whole table and then rebuild it again.
You can of curse add a 'WHERE CLAUSE' to determin which rows shall be
deleted.
This is from the HTML-manual:
Duplicates indicates the
