What is the new IP number?

How is the new IP number being asked?
such as
The table has a number of IP 1000W, today there are 100W IP access,
Today's new IP number, how to quickly find out


I think this is about the 100W IP-one and already existing 1000W IP pairs, if there is a duplication of the deletion, and finally get the new IP. This may get stuck, how to do it quickly.

share to: more

------Solution--------------------
Can't I check it out today's time?
------Solution--------------------
Users visit websites, record visitor IPs, and have new time

Query a time period, IP new record
SELECT * FROM log where fstcreate like "%date (' y-m-d ')%";



------Solution--------------------
Import 100W IP into a temporary table, and compare two tables with the following SQL.

SELECT * from tmp_table where IP isn't in (select IP from IP table)

