Shows Your IPv4 & IPv6, OS, Browser, Organisation, Country on Interactive Map. Live Hosting Information on where any website is hosted on the internet and other information about IP address owners. Online Blacklist your IP Check (Real-time DB). Web Bots 2014 List
IPv4 and IPv6 Live Whois Lookup
My Account  | 
Logout
Login  |  Register  
Add Free Buttons to Your Site

Cities database in SQL / Mysql
Cities States Countries Mysql Sql Database Download

Live Crypto Coin,  
Cryptocurrency Market Analytics
Myip.ms

World Cities/States/Countries SQL & Mysql Database (September 2014 year)     +   Website Script (optional)

We Provide Cities / States / Countries database in Microsoft SQL / Oracle / Mysql formats for use in your applications. All cities / states / countries have their latitude and longitude filled for display on Google map. For example, on user registration page on your website.


Cities States Countries Mysql Sql Database Download

Countries Cities HTML, Php, Jquery Ajax Script for Website


Cities SQL Database Reviews
Our downloadable SQL database have details of -

 



Example of Use (php/jquery script, includes all countries/states/cities) -

 

Country:
States:
Cities:


Download Demo Version in SQL/Mysql format (utf8) to test. We tested cities database on Mysql 5 / Oracle 11 / Microsoft SQL Server 2012.
Demo has the same tables structure as the full version. But it only have 5 selected countries (USA/China/France/Brazil/India), all states for those selected countries and limit 5 cities for each state. Complete list of cities you can see in the example above or by using this link.

  • Price for the full version (Cities/States/Countries SQL & MySQL Database) is   US$249 / 0.62 Bitcoin / 16,600 Feathercoin

  • Price for the PHP Script is FREE (with Cities SQL & MySQL Database). Limited Time Offer. Normal Price is US$50. Cities PHP Script for Website compatible with MySQL only (not MSSQL). It use Php 5 / Mysql 5 / Jquery 1.9 / Html and displays countries/states/cities drop-down ajax list in the same way as you see in our example above.

  • Price for the full version (Cities/States/Countries MySQL Database) + Complete Script for Website (Php/Mysql/Jquery/Html)
    is  US$249 / 0.62 Bitcoin / 16,600 Feathercoin  (Limited Time Offer).    Normal Price is $299.





Buy Now - Select Cities SQL Database, September 2014




Current Version: September 2014


Contact us for more information -
bitcoin payment

Our Bitcoin (BTC) Wallet :
18oq3LjB48584CMwYoseaQGtxRXd4Qvdqo

Bitcoin Payment Instruction


feathercoin payment

Our Feathercoin (FTC) Wallet :
6km7Hp64Lzwn5AgaN84iKp2BGY8xyaT5JJ

Feathercoin Payment Instruction



SQL / MySQL Source Code (truncated) -

/*************************************************************/;
/* A. CREATE TABLE STATEMENT - Microsoft SQL Server / Oracle */;
/*************************************************************/;

/************************************/;
/* COUNTRIES SQL Table  252 records */;
/************************************/;
CREATE TABLE countries (
  countryID varchar(3) NOT NULL,
  countryName varchar(52) NOT NULL,
  localName varchar(45) NOT NULL,
  webCode varchar(2) NOT NULL,
  region varchar(26) NOT NULL,
  continent varchar(15) NOT NULL,
  latitude float NOT NULL,
  longitude float NOT NULL,
  surfaceArea float NOT NULL,
  population int NOT NULL,
  PRIMARY KEY (countryID),
  UNIQUE (webCode),
  UNIQUE (countryName)
);
/************************************/;
/* STATES SQL Table  ~2,800 records */;
/************************************/;
CREATE TABLE states (
  stateID int NOT NULL,
  stateName varchar(50) NOT NULL,
  countryID varchar(3) NOT NULL,
  latitude float NOT NULL,
  longitude float NOT NULL,
  PRIMARY KEY (stateID),
  UNIQUE (countryID,stateName)
);
/*************************************/;
/* CITIES SQL Table  ~141,000 records */;
/*************************************/;
CREATE TABLE cities (
  cityID int NOT NULL,
  cityName varchar(50) NOT NULL,
  stateID int NOT NULL,
  countryID varchar(3) NOT NULL,
  latitude float NOT NULL,
  longitude float NOT NULL,
  PRIMARY KEY (cityID),
  UNIQUE (countryID,stateID,cityID)
);


/*************************************************************/;
/* B.   CREATE TABLE STATEMENT - MySQL Server                */;
/*************************************************************/;

/***************************************/;
/* COUNTRIES MySQL Table  252 records */;
/***************************************/;
CREATE TABLE `countries` (
  `countryID` varchar(3) NOT NULL DEFAULT '',
  `countryName` varchar(52) NOT NULL DEFAULT '',
  `localName` varchar(45) NOT NULL,
  `webCode` varchar(2) NOT NULL,
  `region` varchar(26) NOT NULL,
  `continent` enum('Asia','Europe','North America','Africa','Oceania','Antarctica','South America') NOT NULL,
  `latitude` double NOT NULL DEFAULT '0',
  `longitude` double NOT NULL DEFAULT '0',
  `surfaceArea` float(10,2) NOT NULL DEFAULT '0.00',
  `population` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`countryID`),
  UNIQUE KEY `webCode` (`webCode`),
  UNIQUE KEY `countryName` (`countryName`),
  KEY `region` (`region`),
  KEY `continent` (`continent`),
  KEY `surfaceArea` (`surfaceArea`),
  KEY `population` (`population`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/**************************************/;
/* STATES MySQL Table  ~2,800 records */;
/**************************************/;
CREATE TABLE `states` (
  `stateID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `stateName` varchar(50) NOT NULL DEFAULT '',
  `countryID` varchar(3) NOT NULL,
  `latitude` double NOT NULL DEFAULT '0',
  `longitude` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`stateID`),
  KEY `stateName` (`stateName`),
  KEY `countryID` (`countryID`),
  KEY `unq` (`countryID`,`stateName`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

/***************************************/;
/* CITIES MySQL Table  ~141,000 records */;
/***************************************/;
CREATE TABLE `cities` (
  `cityID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `cityName` varchar(50) NOT NULL,
  `stateID` smallint(5) unsigned NOT NULL DEFAULT '0',
  `countryID` varchar(3) NOT NULL DEFAULT '',
  `latitude` double NOT NULL DEFAULT '0',
  `longitude` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`cityID`),
  UNIQUE KEY `unq` (`countryID`,`stateID`,`cityID`),
  KEY `cityName` (`cityName`),
  KEY `stateID` (`stateID`),
  KEY `countryID` (`countryID`),
  KEY `latitude` (`latitude`),
  KEY `longitude` (`longitude`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
/***************************************/;


/*************************************************************/;
/* C.  Microsoft SQL/Oracle/MySQL Common Table Data          */;
/*************************************************************/;

/* Countries Table Data */
INSERT INTO `countries` (`countryID`, `countryName`, `localName`, `webCode`, `region`, `continent`, 
`latitude`, `longitude`, `surfaceArea`, `population`) VALUES
('BRA', 'Brazil', 'Brasil', 'BR', 'South America', 'South America', -10, -55, 8547403.00, 170115000),
('CHN', 'China', 'Zhongquo', 'CN', 'Eastern Asia', 'Asia', 35, 105, 9572900.00, 1277558000),
('FRA', 'France', 'France', 'FR', 'Western Europe', 'Europe', 47, 2, 551500.00, 59225700),
('IND', 'India', 'Bharat/India', 'IN', 'Southern and Central Asia', 'Asia', 28.47, 77.03, 3287263.00, 1013662000),
('USA', 'USA', 'United States', 'US', 'North America', 'North America', 38, -97, 9363520.00, 278357000);

/* States Table Data */
INSERT INTO `states` (`stateID`, `stateName`, `countryID`, `latitude`, `longitude`) VALUES
(5, 'California', 'USA', 37.42, -122.06),
(6, 'Beijing', 'CHN', 39.93, 116.39),
(9, 'Iowa', 'USA', 43.03, -96.09),
(10, 'New York', 'USA', 40.76, -73.97),
(12, '... ....', 'CHN', 32.06, 118.78);

/* Cities Table Data */
INSERT INTO `cities` (`cityID`, `cityName`, `stateID`, `countryID`, `latitude`, `longitude`) VALUES
(7, 'Mountain View', 5, 'USA', 37.42, -122.06),
(8, 'Beijing', 6, 'CHN', 39.93, 116.39),
(11, 'Ackworth', 9, 'USA', 41.36, -93.43),
(13, 'Far Rockaway', 10, 'USA', 40.61, -73.79),
(14, 'Hebei', 11, 'CHN', 39.89, 115.28),
(15, 'Los Angeles', 5, 'USA', 34.04, -118.25),
(16, '... ... ...', 12, 'CHN', 32.06, 118.78);


  Full Cities/States/Countries MySQL & Sql source code you can download here »




Reviews and Comments
comments powered by Disqus
Reviews and Comments
To share this Review on your website/blog simply copy the following html code below and place it in your web page -
Home SpeedCoin API Countries World Hosting Files / Reports Sitemap Contact Us
SUPPORT US - if you like this website and wish to support further development of myip.ms -
Bitcoin: 1P4oi48drkGL2ZwnRdDk6NBKp83r3s9uAT       Litecoin: LRpJFfCJqZBBFiSTaTewq5mLWJTF7G29yX
Feathercoin: 6fYnDeg4raYJy8P83ZXYoXDZT6SQkoo3yc       Dogecoin: DNoxuJq61bYLMFFRCSUZHDZeV71b6Ybref

Copyright © 2012-2014 Myip.ms. All rights reserved.
All or part of the information on this site may be quoted and reproduced by disclosing the source properly (making a link to the Myip.ms)

           
#1 Global Browsers, Websites & IP Database