// BINGBOT / SQL
Bingbot · SQL

SQL inserts to load Bingbot CIDRs into a database table. 28 CIDRs, refreshed daily.
// bingbot_ips.sql

DOWNLOAD ↓ ·
-- SQL script to create table `bingbot_ips` and insert IP addresses

CREATE TABLE IF NOT EXISTS `bingbot_ips` (
  `ip_address` VARCHAR(45) NOT NULL,
  `ip_type` VARCHAR(10) NOT NULL,
  PRIMARY KEY (`ip_address`)
);

INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('13.66.139.0/24', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('13.66.144.0/24', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('13.67.10.16/28', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('13.69.66.240/28', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('13.71.172.224/28', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('20.15.133.160/27', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('20.36.108.32/28', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('20.43.120.16/28', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('20.74.197.0/28', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('20.79.107.240/28', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('20.125.163.80/28', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('40.77.139.0/25', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('40.77.167.0/24', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('40.77.177.0/24', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('40.77.178.0/23', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('40.77.188.0/22', 'IPv4');
INSERT INTO `bingbot_ips` (`ip_address`, `ip_type`) VALUES ('40.77.202.0/24', 'IPv4');
… (11 more lines)