Can someone please help me with the following: code so far
SELECT DISTINCT ip, COUNT(DISTINCT round_to_nearest_five_minutes(date)) as url_hit_count, request from logs_empty GROUP BY substring_index(request, '/', 3) ; I would like to add on to the the code an additional column that adds up the url_hit_count where the ip column value's are the same. How do I do this? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
