EXPLAIN EXTENDED

How to create fast database queries

Archive for June 8th, 2009

Latest DISTINCT records

Comments enabled. I *really* need your comment

From Stack Overflow:

I have a table containing pagehit data in MySQL.

How do I grab the 10 latest unique IP's from that table?

This is quite a common task and there are two approaches to solve it.

Let's create two sample tables that differ in IP distribution:
Read the rest of this entry »

Written by Quassnoi

June 8th, 2009 at 11:00 pm

Posted in MySQL