How do I find the number of new IP addresses? For example, the table contains million IP addresses and IP addresses today. how can we quickly find the number of new IP addresses today? & nbsp; compare the IP addresses one by one with the existing IP addresses. if there are duplicate IP addresses, delete them and get the new IP addresses. In this case, it may be stuck. how can we do this quickly. How do I find the number of new IP addresses?
For example;
The table already contains million IP addresses. Today, million IP addresses are accessed,
How can I quickly find the number of new IP addresses today?
I think we will probably compare the million IP addresses one by one with the existing million IP addresses. if there are duplicates, we will delete them and get the new IP addresses. In this case, it may be stuck. how can we do this quickly.
Share: More
------ Solution --------------------
Cannot be queried based on today's time?
------ Solution --------------------
The user accesses the website, records the visitor's ip address, and adds the time.
Query New records of ip addresses in a certain time period
Select * from log where fstcreate like "% date ('Y-m-D') % ";
------ Solution --------------------
Import million ip addresses to a temporary table, and then compare the two tables with the following SQL statements.
Select * from tmp_table where ip not in (select ip from ip table)
