SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for customer -- ---------------------------- DROP TABLE IF EXISTS `customer`; CREATE TABLE `customer` ( `id` int (11) unsigned NOT NULL auto_increment COMMENT '自增主键' , ` name ` varchar (50) NOT NULL COMMENT '名称' , `lon` double (9,6) NOT NULL COMMENT '经度' , `lat` double (8,6) NOT NULL COMMENT '纬度' , PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT= '商户表' ; -- ---------------------------- -- Records of customer -- ---------------------------- INSERT INTO `customer` VALUES ( '1' , '天津市区' , '117.315575' , '39.133462' ); INSERT INTO `customer` VALUES ( '2' , '北京市区' , '116.407999' , '39.894073' ); INSERT INTO `customer` VALUES ( '3' , '保定' , '115.557124' , '38.853490' ); INSERT INTO `customer` VALUES ( '4' , '石家庄' , '114.646458' , '38.072369' ); INSERT INTO `customer` VALUES ( '5' , '昌平区1' , '116.367180' , '40.009561' ); INSERT INTO `customer` VALUES ( '6' , '海淀区2' , '116.313425' , '39.973078' ); INSERT INTO `customer` VALUES ( '7' , '海淀区1' , '116.329236' , '39.987231' ); |