dkanavis

Untitled

Oct 10th, 2016
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.08 KB | None | 0 0
  1. mysql> SELECT * FROM geoip_blocks WHERE inet_aton('176.15.57.165') >= startIpNum AND inet_aton('176.15.57.165') < endIpNum;
  2. +------------+------------+-----------------------------+-------------+----------+
  3. | startIpNum | endIpNum | IpTextBlock | CountryCode | CityCode |
  4. +------------+------------+-----------------------------+-------------+----------+
  5. | 2953785600 | 2953787903 | 176.15.49.0 - 176.15.57.255 | RU | 1442 |
  6. +------------+------------+-----------------------------+-------------+----------+
  7. 1 row in set (0.13 sec)
  8.  
  9. mysql> DESC geoip_location;
  10. +-----------+----------------------+------+-----+---------+-------+
  11. | Field | Type | Null | Key | Default | Extra |
  12. +-----------+----------------------+------+-----+---------+-------+
  13. | id | smallint(5) unsigned | NO | PRI | NULL | |
  14. | city | varchar(150) | NO | | NULL | |
  15. | subject | varchar(200) | NO | | NULL | |
  16. | district | varchar(200) | NO | | NULL | |
  17. | latitude | float unsigned | NO | | NULL | |
  18. | longitude | float unsigned | NO | | NULL | |
  19. +-----------+----------------------+------+-----+---------+-------+
  20. 6 rows in set (0.00 sec)
  21.  
  22. mysql> SELECT * FROM geoip_location WHERE id = 1442;
  23. +------+----------------+-----------------------------------+------------------------------------------------------+----------+-----------+
  24. | id | city | subject | district | latitude | longitude |
  25. +------+----------------+-----------------------------------+------------------------------------------------------+----------+-----------+
  26. | 1442 | Иркутск | Иркутская область | Сибирский федеральный округ | 52.2753 | 104.309 |
  27. +------+----------------+-----------------------------------+------------------------------------------------------+----------+-----------+
Advertisement
Add Comment
Please, Sign In to add comment