世界主要城市以及时区

最新推荐文章于 2021-07-19 09:54:46 发布
as65986
最新推荐文章于 2021-07-19 09:54:46 发布
阅读量805
点赞数
文章标签：数据库
原文链接：http://www.cnblogs.com/MrHao/p/7133179.html
版权
世界主要城市以及时区
# MySQL-Front 5.1  (Build 4.13)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;


# Host: localhost    Database: dms
# ------------------------------------------------------
# Server version 5.5.35

USE `dms`;

#
# Source for table tb_major_city
#

DROP TABLE IF EXISTS `tb_major_city`;
CREATE TABLE `tb_major_city` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `CityName` varchar(50) DEFAULT NULL COMMENT '城市名称',
  `CityNameEN` varchar(50) DEFAULT NULL COMMENT '城市英文名称',
  `CountryName` varchar(50) DEFAULT NULL COMMENT '国家名称',
  `TimeZone` int(11) DEFAULT '0' COMMENT '时区',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='世界主要城市';

#
# Dumping data for table tb_major_city
#

INSERT INTO `tb_major_city` VALUES (1,'北京','Beijing','中国',8);
INSERT INTO `tb_major_city` VALUES (2,'夏威夷檀香山','Honolulu','美国',-10);
INSERT INTO `tb_major_city` VALUES (3,'阿拉斯加安克雷奇','Anchorage','美国',-9);
INSERT INTO `tb_major_city` VALUES (4,'温哥华','Vancouver','加拿大',-8);
INSERT INTO `tb_major_city` VALUES (5,'旧金山','San Francisco','美国',-8);
INSERT INTO `tb_major_city` VALUES (6,'西雅图','Seattle','美国',-8);
INSERT INTO `tb_major_city` VALUES (7,'洛杉矶','Los Angeles','美国',-8);
INSERT INTO `tb_major_city` VALUES (8,'阿克拉维克','Aklavik','加拿大',-7);
INSERT INTO `tb_major_city` VALUES (9,'艾德蒙顿','Edmonton','加拿大',-7);
INSERT INTO `tb_major_city` VALUES (10,'凤凰城','Phoenix','美国',-7);
INSERT INTO `tb_major_city` VALUES (11,'丹佛','Denver','美国',-7);
INSERT INTO `tb_major_city` VALUES (12,'墨西哥城','Mexico City','墨西哥',-6);
INSERT INTO `tb_major_city` VALUES (13,'温尼伯','Winnipeg','加拿大',-6);
INSERT INTO `tb_major_city` VALUES (14,'休斯敦','Houston','美国',-6);
INSERT INTO `tb_major_city` VALUES (15,'明尼亚波利斯','Minneapolis','美国',-6);
INSERT INTO `tb_major_city` VALUES (16,'圣保罗','St. Paul','美国',-6);
INSERT INTO `tb_major_city` VALUES (17,'新奥尔良','New Orleans','美国',-6);
INSERT INTO `tb_major_city` VALUES (18,'芝加哥','Chicago','美国',-6);
INSERT INTO `tb_major_city` VALUES (19,'蒙哥马利','Montgomery','美国',-6);
INSERT INTO `tb_major_city` VALUES (20,'危地马拉','Guatemala','危地马拉',-6);
INSERT INTO `tb_major_city` VALUES (21,'圣萨尔瓦多','San Salvador','萨尔瓦多',-6);
INSERT INTO `tb_major_city` VALUES (22,'特古西加尔巴','Tegucigalpa','洪都拉斯',-6);
INSERT INTO `tb_major_city` VALUES (23,'马那瓜','Managua','尼加拉瓜',-6);
INSERT INTO `tb_major_city` VALUES (24,'哈瓦那','Havana','古巴',-5);
INSERT INTO `tb_major_city` VALUES (25,'印地安纳波利斯','Indianapolis','美国',-5);
INSERT INTO `tb_major_city` VALUES (26,'亚特兰大','Atlanta','美国',-5);
INSERT INTO `tb_major_city` VALUES (27,'底特律','Detroit','美国',-5);
INSERT INTO `tb_major_city` VALUES (28,'华盛顿哥伦比亚特区','Washington DC','美国',-5);
INSERT INTO `tb_major_city` VALUES (29,'费城','Philadelphia','美国',-5);
INSERT INTO `tb_major_city` VALUES (30,'多伦多','Toronto','加拿大',-5);
INSERT INTO `tb_major_city` VALUES (31,'渥太华','Ottawa','加拿大',-5);
INSERT INTO `tb_major_city` VALUES (32,'拿骚','Nassau','巴哈马',-5);
INSERT INTO `tb_major_city` VALUES (33,'利马','Lima','秘鲁',-5);
INSERT INTO `tb_major_city` VALUES (34,'金斯敦','Kingston','牙买加',-5);
INSERT INTO `tb_major_city` VALUES (35,'波哥大','Bogota','哥伦比亚',-5);
INSERT INTO `tb_major_city` VALUES (36,'纽约','New York','美国',-5);
INSERT INTO `tb_major_city` VALUES (37,'蒙特利尔','Montreal','加拿大',-5);
INSERT INTO `tb_major_city` VALUES (38,'波士顿','Boston','美国',-5);
INSERT INTO `tb_major_city` VALUES (39,'圣多明各','Santo Domingo','多米尼加',-5);
INSERT INTO `tb_major_city` VALUES (40,'拉帕兹','La Paz','玻利维亚',-5);
INSERT INTO `tb_major_city` VALUES (41,'加拉加斯','Caracas','委内瑞拉',-5);
INSERT INTO `tb_major_city` VALUES (42,'圣胡安','San Juan','波多黎各',-5);
INSERT INTO `tb_major_city` VALUES (43,'哈里法克斯','Halifax','加拿大',-5);
INSERT INTO `tb_major_city` VALUES (44,'圣地亚哥','Santiago','智利',-4);
INSERT INTO `tb_major_city` VALUES (45,'亚松森','Asuncion','巴拉圭',-4);
INSERT INTO `tb_major_city` VALUES (46,'圣约翰斯','St. John\'s','加拿大',-4);
INSERT INTO `tb_major_city` VALUES (47,'布宜诺斯艾利斯','Buenos Aires','阿根廷',-3);
INSERT INTO `tb_major_city` VALUES (48,'蒙特维的亚','Montevideo','乌拉圭',-3);
INSERT INTO `tb_major_city` VALUES (49,'巴西利亚','Brasilia','巴西',-3);
INSERT INTO `tb_major_city` VALUES (50,'圣保罗','Sao Paulo','巴西',-3);
INSERT INTO `tb_major_city` VALUES (51,'里约热内卢','Rio de Janeiro','巴西',-3);
INSERT INTO `tb_major_city` VALUES (52,'雷克雅未克','Reykjavik','冰岛',0);
INSERT INTO `tb_major_city` VALUES (53,'里斯本','Lisbon','葡萄牙',0);
INSERT INTO `tb_major_city` VALUES (54,'卡萨布兰卡','Casablanca','摩洛哥',0);
INSERT INTO `tb_major_city` VALUES (55,'都柏林','Dublin','爱尔兰',0);
INSERT INTO `tb_major_city` VALUES (56,'伦敦','London','英国',0);
INSERT INTO `tb_major_city` VALUES (57,'马德里','Madrid','西班牙',1);
INSERT INTO `tb_major_city` VALUES (58,'巴塞罗那','Barcelona','西班牙',1);
INSERT INTO `tb_major_city` VALUES (59,'巴黎','Paris','法国',1);
INSERT INTO `tb_major_city` VALUES (60,'拉各斯','Lagos','尼日利亚',1);
INSERT INTO `tb_major_city` VALUES (61,'阿尔及尔','Algiers','阿尔及利亚',1);
INSERT INTO `tb_major_city` VALUES (62,'布鲁塞尔','Brussels','比利时',1);
INSERT INTO `tb_major_city` VALUES (63,'阿姆斯特丹','Amsterdam','荷兰',1);
INSERT INTO `tb_major_city` VALUES (64,'日内瓦','Geneva','瑞士',1);
INSERT INTO `tb_major_city` VALUES (65,'苏黎世','Zurich','瑞士',1);
INSERT INTO `tb_major_city` VALUES (66,'法兰克福','Frankfurt','德国',1);
INSERT INTO `tb_major_city` VALUES (67,'奥斯陆','Oslo','挪威',1);
INSERT INTO `tb_major_city` VALUES (68,'哥本哈根','Copenhagen','丹麦',1);
INSERT INTO `tb_major_city` VALUES (69,'罗马','Rome','意大利',1);
INSERT INTO `tb_major_city` VALUES (70,'柏林','Berlin','德国',1);
INSERT INTO `tb_major_city` VALUES (71,'布拉格','Prague','捷克',1);
INSERT INTO `tb_major_city` VALUES (72,'萨格雷布','Zagreb','克罗地亚',1);
INSERT INTO `tb_major_city` VALUES (73,'维也纳','Vienna','奥地利',1);
INSERT INTO `tb_major_city` VALUES (74,'斯德哥尔摩','Stockholm','瑞典',1);
INSERT INTO `tb_major_city` VALUES (75,'布达佩斯','Budapest','匈牙利',1);
INSERT INTO `tb_major_city` VALUES (76,'贝尔格莱德','Belgrade','塞尔维亚与蒙特内哥罗',1);
INSERT INTO `tb_major_city` VALUES (77,'华沙','Warsaw','波兰',1);
INSERT INTO `tb_major_city` VALUES (78,'开普敦','Cape Town','南非',2);
INSERT INTO `tb_major_city` VALUES (79,'索非亚','Sofia','保加利亚',2);
INSERT INTO `tb_major_city` VALUES (80,'雅典城','Athens','希腊',2);
INSERT INTO `tb_major_city` VALUES (81,'塔林','Tallinn','爱沙尼亚',2);
INSERT INTO `tb_major_city` VALUES (82,'赫尔辛基','Helsinki','芬兰',2);
INSERT INTO `tb_major_city` VALUES (83,'布加勒斯特','Bucharest','罗马尼亚',2);
INSERT INTO `tb_major_city` VALUES (84,'明斯克','Minsk','白俄罗斯',2);
INSERT INTO `tb_major_city` VALUES (85,'约翰尼斯堡','Johannesburg','南非',2);
INSERT INTO `tb_major_city` VALUES (86,'伊斯坦布尔','Istanbul','土耳其',2);
INSERT INTO `tb_major_city` VALUES (87,'基辅','Kyiv','乌克兰',2);
INSERT INTO `tb_major_city` VALUES (88,'敖德萨','Odesa','乌克兰',2);
INSERT INTO `tb_major_city` VALUES (89,'哈拉雷','Harare','津巴布韦',2);
INSERT INTO `tb_major_city` VALUES (90,'开罗','Cairo','埃及',2);
INSERT INTO `tb_major_city` VALUES (91,'安卡拉','Ankara','土耳其',2);
INSERT INTO `tb_major_city` VALUES (92,'耶路撒冷','Jerusalem','以色列',2);
INSERT INTO `tb_major_city` VALUES (93,'贝鲁特','Beirut','黎巴嫩',2);
INSERT INTO `tb_major_city` VALUES (94,'安曼','Amman','约旦',2);
INSERT INTO `tb_major_city` VALUES (95,'喀土穆','Khartoum','苏丹',3);
INSERT INTO `tb_major_city` VALUES (96,'内罗毕','Nairobi','肯尼亚',3);
INSERT INTO `tb_major_city` VALUES (97,'莫斯科','Moscow','俄罗斯',3);
INSERT INTO `tb_major_city` VALUES (98,'亚的斯亚贝巴','Addis Ababa','埃塞俄比亚',3);
INSERT INTO `tb_major_city` VALUES (99,'巴格达','Baghdad','伊拉克',3);
INSERT INTO `tb_major_city` VALUES (100,'亚丁','Aden','也门',3);
INSERT INTO `tb_major_city` VALUES (101,'利雅得','Riyadh','沙特阿拉伯',3);
INSERT INTO `tb_major_city` VALUES (102,'安塔那那利佛','Antananarivo','马达加斯加',3);
INSERT INTO `tb_major_city` VALUES (103,'科威特城','Kuwait City','科威特',3);
INSERT INTO `tb_major_city` VALUES (104,'德黑兰','Tehran','伊朗',3);
INSERT INTO `tb_major_city` VALUES (105,'阿布扎比','Abu Dhabi','阿拉伯联合酋长国',4);
INSERT INTO `tb_major_city` VALUES (106,'喀布尔','Kabul','阿富汗',4);
INSERT INTO `tb_major_city` VALUES (107,'卡拉奇','Karachi','巴基斯坦',5);
INSERT INTO `tb_major_city` VALUES (108,'塔什干','Tashkent','乌兹别克斯坦',5);
INSERT INTO `tb_major_city` VALUES (109,'伊斯兰堡','Islamabad','巴基斯坦',5);
INSERT INTO `tb_major_city` VALUES (110,'拉合尔','Lahore','巴基斯坦',5);
INSERT INTO `tb_major_city` VALUES (111,'孟买','Mumbai','印度',5);
INSERT INTO `tb_major_city` VALUES (112,'新德里','New Delhi','印度',5);
INSERT INTO `tb_major_city` VALUES (113,'柯尔喀塔','Kolkata','印度',5);
INSERT INTO `tb_major_city` VALUES (114,'加德满都','Kathmandu','尼泊尔',5);
INSERT INTO `tb_major_city` VALUES (115,'达卡','Dhaka','孟加拉',6);
INSERT INTO `tb_major_city` VALUES (116,'仰光','Yangon','缅甸',6);
INSERT INTO `tb_major_city` VALUES (117,'金边','Phnom Penh','柬埔寨',7);
INSERT INTO `tb_major_city` VALUES (118,'曼谷','Bangkok','泰国',7);
INSERT INTO `tb_major_city` VALUES (119,'河内','Hanoi','越南',7);
INSERT INTO `tb_major_city` VALUES (120,'雅加达','Jakarta','印尼',7);
INSERT INTO `tb_major_city` VALUES (121,'吉隆坡','Kuala Lumpur','马来西亚',8);
INSERT INTO `tb_major_city` VALUES (122,'新加坡','Singapore','新加坡',8);
INSERT INTO `tb_major_city` VALUES (123,'香港','Hong Kong','中国',8);
INSERT INTO `tb_major_city` VALUES (124,'珀斯','Perth','澳大利亚',8);
INSERT INTO `tb_major_city` VALUES (125,'马尼拉','Manila','菲律宾',8);
INSERT INTO `tb_major_city` VALUES (126,'上海','Shanghai','中国',8);
INSERT INTO `tb_major_city` VALUES (127,'台北','Taipei','中国',8);
INSERT INTO `tb_major_city` VALUES (128,'首尔(汉城)','Seoul','韩国',9);
INSERT INTO `tb_major_city` VALUES (129,'东京','Tokyo','日本',9);
INSERT INTO `tb_major_city` VALUES (130,'达尔文','Darwin','澳大利亚',9);
INSERT INTO `tb_major_city` VALUES (131,'符拉迪沃斯托克(海参崴)','Vladivostok','俄罗斯',10);
INSERT INTO `tb_major_city` VALUES (132,'布里斯班','Brisbane','澳大利亚',10);
INSERT INTO `tb_major_city` VALUES (133,'墨尔本','Melbourne','澳大利亚',10);
INSERT INTO `tb_major_city` VALUES (134,'堪培拉','Canberra','澳大利亚',10);
INSERT INTO `tb_major_city` VALUES (135,'悉尼','Sydney','澳大利亚',10);
INSERT INTO `tb_major_city` VALUES (136,'亚特雷德','Adelaide','澳大利亚',9);
INSERT INTO `tb_major_city` VALUES (137,'堪察加','Kamchatka','俄罗斯',12);
INSERT INTO `tb_major_city` VALUES (138,'阿纳德尔','Anadyr','俄罗斯',12);
INSERT INTO `tb_major_city` VALUES (139,'苏瓦','Suva','斐济',12);
INSERT INTO `tb_major_city` VALUES (140,'惠灵顿','Wellington','新西兰',12);
INSERT INTO `tb_major_city` VALUES (141,'查塔姆群岛','Chatham Island','新西兰',12);
INSERT INTO `tb_major_city` VALUES (142,'圣诞岛','Kiritimati','基里巴斯',-10);

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
转载于:https://www.cnblogs.com/MrHao/p/7133179.html
as65986
关注
0
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
世界主要城市以及时区

世界主要城市以及时区# MySQL-Front 5.1 (Build 4.13)/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;/*!40111 SE...
复制链接

扫一扫