国内城市翻译

博客展示了一系列向 `dictionary` 表插入中英文数据的 SQL 语句,插入内容包含众多中国城市、省份及地区的中英文名称,如上海(shanghai)、北京(Peking)等,主要围绕数据库的数据插入操作。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

INSERT INTO `dictionary` (chinese, english) VALUES ('上海', 'shanghai');
INSERT INTO `dictionary` (chinese, english) VALUES ('北京', 'Peking');
INSERT INTO `dictionary` (chinese, english) VALUES ('天津', 'Tianjin');
INSERT INTO `dictionary` (chinese, english) VALUES ('重庆', 'Chongqing');
INSERT INTO `dictionary` (chinese, english) VALUES ('哈尔滨', 'Haerbin');
INSERT INTO `dictionary` (chinese, english) VALUES ('沈阳', 'ShenYang');
INSERT INTO `dictionary` (chinese, english) VALUES ('长春', 'Changchun');
INSERT INTO `dictionary` (chinese, english) VALUES ('石家庄', 'Shijiazhuang');
INSERT INTO `dictionary` (chinese, english) VALUES ('济南', 'Jinan');
INSERT INTO `dictionary` (chinese, english) VALUES ('太原', 'Taiyuan');
INSERT INTO `dictionary` (chinese, english) VALUES ('郑州', 'Zhengzhou');
INSERT INTO `dictionary` (chinese, english) VALUES ('武汉', 'Wuhan');
INSERT INTO `dictionary` (chinese, english) VALUES ('西安', 'Xian');
INSERT INTO `dictionary` (chinese, english) VALUES ('乌鲁木齐', 'Wulumuqi');
INSERT INTO `dictionary` (chinese, english) VALUES ('成都', 'Chengdou');
INSERT INTO `dictionary` (chinese, english) VALUES ('贵阳', 'Guiyang');
INSERT INTO `dictionary` (chinese, english) VALUES ('桂林', 'Guilin');
INSERT INTO `dictionary` (chinese, english) VALUES ('广州', 'GuangZhou');
INSERT INTO `dictionary` (chinese, english) VALUES ('南昌', 'Nanchang');
INSERT INTO `dictionary` (chinese, english) VALUES ('福州', 'Fuzhou');
INSERT INTO `dictionary` (chinese, english) VALUES ('杭州', 'Hangzhou');
INSERT INTO `dictionary` (chinese, english) VALUES ('长沙', 'Changsha');
INSERT INTO `dictionary` (chinese, english) VALUES ('深圳', 'Shenzhen');
INSERT INTO `dictionary` (chinese, english) VALUES ('香港', 'Hongkong');
INSERT INTO `dictionary` (chinese, english) VALUES ('澳门', 'Macao');
INSERT INTO `dictionary` (chinese, english) VALUES ('台北', 'Taibei');
INSERT INTO `dictionary` (chinese, english) VALUES ('兰州', 'Lanzhou');
INSERT INTO `dictionary` (chinese, english) VALUES ('西宁', 'Xining');
INSERT INTO `dictionary` (chinese, english) VALUES ('南宁', 'Nanning');
INSERT INTO `dictionary` (chinese, english) VALUES ('苏州', 'Suzhou');
INSERT INTO `dictionary` (chinese, english) VALUES ('无锡', 'Wuxi');
INSERT INTO `dictionary` (chinese, english) VALUES ('扬州', 'Yangzhou');
INSERT INTO `dictionary` (chinese, english) VALUES ('杨凌', 'Yangling');
INSERT INTO `dictionary` (chinese, english) VALUES ('宝鸡', 'Baoji');
INSERT INTO `dictionary` (chinese, english) VALUES ('南京', 'Nanjing');
INSERT INTO `dictionary` (chinese, english) VALUES ('承德', 'Chengde');
INSERT INTO `dictionary` (chinese, english) VALUES ('秦皇岛', 'Qinhuangdao');
INSERT INTO `dictionary` (chinese, english) VALUES ('邢台', 'Xingtai');
INSERT INTO `dictionary` (chinese, english) VALUES ('保定', 'Baoding');
INSERT INTO `dictionary` (chinese, english) VALUES ('呼和浩特', 'Huhehaote');
INSERT INTO `dictionary` (chinese, english) VALUES ('包头', 'Baotou');
INSERT INTO `dictionary` (chinese, english) VALUES ('大连', 'Dalian');
INSERT INTO `dictionary` (chinese, english) VALUES ('丹东', 'Dandong');
INSERT INTO `dictionary` (chinese, english) VALUES ('大庆', 'Daqing');
INSERT INTO `dictionary` (chinese, english) VALUES ('常州', 'Changzhou');
INSERT INTO `dictionary` (chinese, english) VALUES ('徐州', 'Xuzhou');
INSERT INTO `dictionary` (chinese, english) VALUES ('南通', 'Nantong');
INSERT INTO `dictionary` (chinese, english) VALUES ('镇江', 'Zhenjiang');
INSERT INTO `dictionary` (chinese, english) VALUES ('连云港', 'Lianyungang');
INSERT INTO `dictionary` (chinese, english) VALUES ('张家港', 'Zhangjiagang');
INSERT INTO `dictionary` (chinese, english) VALUES ('江阴', 'Jiangyin');
INSERT INTO `dictionary` (chinese, english) VALUES ('宁波', 'Ningbo');
INSERT INTO `dictionary` (chinese, english) VALUES ('温州', 'Wenzhou');
INSERT INTO `dictionary` (chinese, english) VALUES ('绍兴', 'Shaoxing');
INSERT INTO `dictionary` (chinese, english) VALUES ('永康', 'Yongkang');
INSERT INTO `dictionary` (chinese, english) VALUES ('义乌', 'Yiwu');
INSERT INTO `dictionary` (chinese, english) VALUES ('嘉兴', 'Jiaxing');
INSERT INTO `dictionary` (chinese, english) VALUES ('诸暨', 'Zhuji');
INSERT INTO `dictionary` (chinese, english) VALUES ('临海', 'Linhai');
INSERT INTO `dictionary` (chinese, english) VALUES ('路桥', 'Luqiao');
INSERT INTO `dictionary` (chinese, english) VALUES ('慈溪', 'Cixi');
INSERT INTO `dictionary` (chinese, english) VALUES ('合肥', 'Hefei');
INSERT INTO `dictionary` (chinese, english) VALUES ('黄山', 'Huangshan');
INSERT INTO `dictionary` (chinese, english) VALUES ('芜湖', 'Wuhu');
INSERT INTO `dictionary` (chinese, english) VALUES ('厦门', 'Xiamen');
INSERT INTO `dictionary` (chinese, english) VALUES ('泉州', 'Quanzhou');
INSERT INTO `dictionary` (chinese, english) VALUES ('武夷山', 'Wuyishan');
INSERT INTO `dictionary` (chinese, english) VALUES ('石狮', 'Shishi');
INSERT INTO `dictionary` (chinese, english) VALUES ('莆田', 'Putian');
INSERT INTO `dictionary` (chinese, english) VALUES ('九江', 'Jiujiang');
INSERT INTO `dictionary` (chinese, english) VALUES ('青岛', 'Qingdao');
INSERT INTO `dictionary` (chinese, english) VALUES ('潍坊', 'Weifang');
INSERT INTO `dictionary` (chinese, english) VALUES ('烟台', 'Yantai');
INSERT INTO `dictionary` (chinese, english) VALUES ('威海', 'Weihai');
INSERT INTO `dictionary` (chinese, english) VALUES ('淄博', 'Zibo');
INSERT INTO `dictionary` (chinese, english) VALUES ('临沂', 'Linyi');
INSERT INTO `dictionary` (chinese, english) VALUES ('泰安', 'Taian');
INSERT INTO `dictionary` (chinese, english) VALUES ('洛阳', 'Luoyang');
INSERT INTO `dictionary` (chinese, english) VALUES ('开封', 'Kaifeng');
INSERT INTO `dictionary` (chinese, english) VALUES ('新乡', 'Xinxiang');
INSERT INTO `dictionary` (chinese, english) VALUES ('宜昌', 'yichang');
INSERT INTO `dictionary` (chinese, english) VALUES ('襄樊', 'xiangfan');
INSERT INTO `dictionary` (chinese, english) VALUES ('十堰', 'Shiyan');
INSERT INTO `dictionary` (chinese, english) VALUES ('武穴', 'Wuxue');
INSERT INTO `dictionary` (chinese, english) VALUES ('张家界', 'Zhangjiajie');
INSERT INTO `dictionary` (chinese, english) VALUES ('汕头', 'Shantou');
INSERT INTO `dictionary` (chinese, english) VALUES ('珠海', 'Zhuhai');
INSERT INTO `dictionary` (chinese, english) VALUES ('佛山', 'Fuoshan');
INSERT INTO `dictionary` (chinese, english) VALUES ('东莞', 'Dongguan');
INSERT INTO `dictionary` (chinese, english) VALUES ('澄海', 'Chenghai');
INSERT INTO `dictionary` (chinese, english) VALUES ('茂名', 'Maoming');
INSERT INTO `dictionary` (chinese, english) VALUES ('惠州', 'Huizhou');
INSERT INTO `dictionary` (chinese, english) VALUES ('中山', 'Zhongshan');
INSERT INTO `dictionary` (chinese, english) VALUES ('顺德', 'Shunde');
INSERT INTO `dictionary` (chinese, english) VALUES ('肇庆', 'Zhaoqing');
INSERT INTO `dictionary` (chinese, english) VALUES ('湛江', 'Zhanjing');
INSERT INTO `dictionary` (chinese, english) VALUES ('番禺', 'Fanyu');
INSERT INTO `dictionary` (chinese, english) VALUES ('南宁', 'Nanning');
INSERT INTO `dictionary` (chinese, english) VALUES ('北海', 'Beihai');
INSERT INTO `dictionary` (chinese, english) VALUES ('三亚', 'Sanya');
INSERT INTO `dictionary` (chinese, english) VALUES ('海口', 'Haikou');
INSERT INTO `dictionary` (chinese, english) VALUES ('绵阳', 'Mianyang');
INSERT INTO `dictionary` (chinese, english) VALUES ('乐山', 'Leshan');
INSERT INTO `dictionary` (chinese, english) VALUES ('自贡', 'Zigong');
INSERT INTO `dictionary` (chinese, english) VALUES ('雅安', 'Yaan');
INSERT INTO `dictionary` (chinese, english) VALUES ('都江堰', 'Dujiangyan');
INSERT INTO `dictionary` (chinese, english) VALUES ('宜宾', 'Yibin');
INSERT INTO `dictionary` (chinese, english) VALUES ('南充', 'Nanchong');
INSERT INTO `dictionary` (chinese, english) VALUES ('峨眉山', 'Emeishan');
INSERT INTO `dictionary` (chinese, english) VALUES ('昆明', 'Kunming');
INSERT INTO `dictionary` (chinese, english) VALUES ('丽江', 'Lijiang');
INSERT INTO `dictionary` (chinese, english) VALUES ('拉萨', 'Lasa');
INSERT INTO `dictionary` (chinese, english) VALUES ('敦煌', 'Dunhuang');
INSERT INTO `dictionary` (chinese, english) VALUES ('银川', 'Yinchuan');
INSERT INTO `dictionary` (chinese, english) VALUES ('河北', 'Hebei');
INSERT INTO `dictionary` (chinese, english) VALUES ('山西', 'Shanxi');
INSERT INTO `dictionary` (chinese, english) VALUES ('辽宁', 'Liaoning');
INSERT INTO `dictionary` (chinese, english) VALUES ('吉林', 'jilin');
INSERT INTO `dictionary` (chinese, english) VALUES ('黑龙江', 'heilongjiang');
INSERT INTO `dictionary` (chinese, english) VALUES ('江苏', 'jiangsu');
INSERT INTO `dictionary` (chinese, english) VALUES ('浙江', 'zhejiang');
INSERT INTO `dictionary` (chinese, english) VALUES ('安徽', 'anhui');
INSERT INTO `dictionary` (chinese, english) VALUES ('福建', 'fujian');
INSERT INTO `dictionary` (chinese, english) VALUES ('江西', 'jiangxi');
INSERT INTO `dictionary` (chinese, english) VALUES ('山东', 'shandong');
INSERT INTO `dictionary` (chinese, english) VALUES ('河南', 'henan');
INSERT INTO `dictionary` (chinese, english) VALUES ('湖北', 'hubei');
INSERT INTO `dictionary` (chinese, english) VALUES ('湖南', 'hunan');
INSERT INTO `dictionary` (chinese, english) VALUES ('广东', 'guangdong');
INSERT INTO `dictionary` (chinese, english) VALUES ('海南', 'hainan');
INSERT INTO `dictionary` (chinese, english) VALUES ('四川', 'sichuan');
INSERT INTO `dictionary` (chinese, english) VALUES ('贵州', 'guizhou');
INSERT INTO `dictionary` (chinese, english) VALUES ('云南', 'yunnan');
INSERT INTO `dictionary` (chinese, english) VALUES ('陕西', 'shanxi');
INSERT INTO `dictionary` (chinese, english) VALUES ('甘肃', 'gansu');
INSERT INTO `dictionary` (chinese, english) VALUES ('青海', 'qinghai');
INSERT INTO `dictionary` (chinese, english) VALUES ('台湾', 'taiwan');
INSERT INTO `dictionary` (chinese, english) VALUES ('内蒙古', 'neimenggu');
INSERT INTO `dictionary` (chinese, english) VALUES ('广西', 'guangxi');
INSERT INTO `dictionary` (chinese, english) VALUES ('西藏', 'Tibet');
INSERT INTO `dictionary` (chinese, english) VALUES ('宁夏', 'ningxia');
INSERT INTO `dictionary` (chinese, english) VALUES ('新疆', 'Sinkiang');
INSERT INTO `dictionary` (chinese, english) VALUES ('香港', 'Hongkong');
INSERT INTO `dictionary` (chinese, english) VALUES ('澳门', 'Macao');
CREATE TABLE `cn_base_district` ( `district_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '索引ID', `district_name` varchar(50) NOT NULL COMMENT '地区名称', `district_name_en` varchar(50) NOT NULL DEFAULT '', `district_parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '地区父ID', `district_displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `district_region` varchar(3) NOT NULL DEFAULT '' COMMENT '大区名称', `district_is_level` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '地区深度,从1开始', `district_is_leaf` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '无子类', PRIMARY KEY (`district_id`), KEY `area_parent_id` (`district_parent_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=46743 DEFAULT CHARSET=utf8 COMMENT='地区表'; -- ---------------------------- -- Records of cn_base_district -- ---------------------------- INSERT INTO `cn_base_district` VALUES ('1', '北京市', 'BeiJing City', '0', '0', '华北', '1', '0'); INSERT INTO `cn_base_district` VALUES ('2', '天津市', 'TianJin City', '0', '0', '华北', '1', '0'); CREATE TABLE `cn_base_district` ( `district_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '索引ID', `district_name` varchar(50) NOT NULL COMMENT '地区名称', `district_name_en` varchar(50) NOT NULL DEFAULT '', `district_parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '地区父ID', `district_displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `district_region` varchar(3) NOT NULL DEFAULT '' COMMENT '大区名称', `district_is_level` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '地区深度,从1开始', `district_is_leaf` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '无子类', PRIMARY KEY (`district_id`), KEY `area_parent_id` (`district_parent_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=46743 DEFAULT CHARSET=utf8 COMMENT='地区表'; -- ---------------------------- -- Records of cn_base_district -- ---------------------------- INSERT INTO `cn_base_district` VALUES ('1', '北京市', 'BeiJing City', '0', '0', '华北', '1', '0
内容概要:本文针对国内加密货币市场预测研究较少的现状,采用BP神经网络构建了CCi30指数预测模型。研究选取2018年3月1日至2019年3月26日共391天的数据作为样本,通过“试凑法”确定最优隐结点数目,建立三层BP神经网络模型对CCi30指数收盘价进行预测。论文详细介绍了数据预处理、模型构建、训练及评估过程,包括数据归一化、特征工程、模型架构设计(如输入层、隐藏层、输出层)、模型编译与训练、模型评估(如RMSE、MAE计算)以及结果可视化。研究表明,该模型在短期内能较准确地预测指数变化趋势。此外,文章还讨论了隐层节点数的优化方法及其对预测性能的影响,并提出了若干改进建议,如引入更多技术指标、优化模型架构、尝试其他时序模型等。 适合人群:对加密货币市场预测感兴趣的研究人员、投资者及具备一定编程基础的数据分析师。 使用场景及目标:①为加密货币市场投资者提供一种新的预测工具和方法;②帮助研究人员理解BP神经网络在时间序列预测中的应用;③为后续研究提供改进方向,如数据增强、模型优化、特征工程等。 其他说明:尽管该模型在短期内表现出良好的预测性能,但仍存在一定局限性,如样本量较小、未考虑外部因素影响等。因此,在实际应用中需谨慎对待模型预测结果,并结合其他分析工具共同决策。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值