Mathias,
Hi, look at group by ... with rollup at : http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
Thank you very much for your help.
My needs aren�t this, exactly.
GROUP BY WITH ROLLUP, returns me several lines of the same day (one per IP), plus the total.
I need that every year-month-day-ip be counted as 1. And I need this total per day.
Thank you,
Ronan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
