Advertisement
kn0tsel

IPRangeByCountry-00

Feb 6th, 2012
387
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.23 KB | None | 0 0
  1. mysql> select * from IPRangeByCountry limit 10;
  2. +-----------+-------------+----------+----------+-------------+-------------+-----+
  3. | FromIP    | ToIP        | FromInt  | ToInt    | CountryCode | CountryName | _id |
  4. +-----------+-------------+----------+----------+-------------+-------------+-----+
  5. | 1.0.0.0   | 1.0.0.255   | 16777216 | 16777471 | AU          | Australia   |   1 |
  6. | 1.0.1.0   | 1.0.3.255   | 16777472 | 16778239 | CN          | China       |   2 |
  7. | 1.0.4.0   | 1.0.7.255   | 16778240 | 16779263 | AU          | Australia   |   3 |
  8. | 1.0.8.0   | 1.0.15.255  | 16779264 | 16781311 | CN          | China       |   4 |
  9. | 1.0.16.0  | 1.0.31.255  | 16781312 | 16785407 | JP          | Japan       |   5 |
  10. | 1.0.32.0  | 1.0.63.255  | 16785408 | 16793599 | CN          | China       |   6 |
  11. | 1.0.64.0  | 1.0.127.255 | 16793600 | 16809983 | JP          | Japan       |   7 |
  12. | 1.0.128.0 | 1.0.255.255 | 16809984 | 16842751 | TH          | Thailand    |   8 |
  13. | 1.1.0.0   | 1.1.0.255   | 16842752 | 16843007 | CN          | China       |   9 |
  14. | 1.1.1.0   | 1.1.1.255   | 16843008 | 16843263 | AU          | Australia   |  10 |
  15. +-----------+-------------+----------+----------+-------------+-------------+-----+
  16. 10 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement