I have two table first (countries) one is like this with over 90k recored
fromip toip twocode fullcode
16777216 16777471 AU AUSTRALIA
16777472 16843007 - -
16843008 16843263 AU AUSTRALIA
20054016 20055039 AU AUSTRALIA
20055040 33488895 - -
33488896 33554431 AU AUSTRALIA
33554432 33686271 UK UNITED KINGDOM
33686272 50331647 - -
and the second table is (referrer) with 100k recored and empty country feild
id ip country
1 188.49.83.229
2 41.226.108.77
3 86.108.51.36
4 41.129.10.205
5 41.238.147.221
6 213.186.175.39
what I want is to run this query
update `referrer` as a set a.country = (select twocode from country as b where INET_ATON(a.ip) between b.fromip and b.toip ) WHERE a.ip is not null
Now when I try to run this, the whole site freeze, any idea what can I do? thanks alot in advance
Edited 1 time(s). Last edit at 02/28/2010 09:09AM by lamis beirkdar.