2015年9月15号工作总结

原创
2015/09/16 09:21
阅读数 41

以前的我总是那么的浮躁,总是认为自己很了不起,什么都能做,在公司也懒懒散散,现在的我要努力,好好的工作,努力学习技术

今天遇到的问题是,公司的有一张表中的province(省份)里面的字段很乱,因为有迁移过来的数据,存的什么都有,查询的很不准确,没办法只能手动先修改一下数据库了

update tabmembers set province='河南省' where province in ('HA','河南');
update tabmembers set province='北京市' where province in ('BJ','北京');
update tabmembers set province='天津市' where province in ('TJ','天津');
update tabmembers set province='上海市' where province in ('SH','上海');
update tabmembers set province='重庆市' where province in ('CQ','重庆');
update tabmembers set province='河北省' where province in ('HE','河北');
update tabmembers set province='山西省' where province in ('SX','山西');
update tabmembers set province='台湾省' where province in ('TW','台湾');
update tabmembers set province='辽宁省' where province in ('LN','辽宁');
update tabmembers set province='吉林省' where province in ('JL','吉林');
update tabmembers set province='黑龙江省' where province in ('HL','黑龙江');
update tabmembers set province='湖北省' where province in ('HB','湖北');
update tabmembers set province='安徽省' where province in ('AH','安徽');
update tabmembers set province='福建省' where province in ('FJ','福建');
update tabmembers set province='甘肃省' where province in ('GS','甘肃');
update tabmembers set province='广东省' where province in ('GD','广东');
update tabmembers set province='广西壮族自治区' where province in ('GX','广西');
update tabmembers set province='贵州省' where province in ('GZ','贵州');
update tabmembers set province='海南省' where province in ('HI','海南');
update tabmembers set province='湖南省' where province in ('HN','湖南');
update tabmembers set province='江苏省' where province in ('JS','江苏');
update tabmembers set province='江西省' where province in ('JX','江西');
update tabmembers set province='内蒙古自治区' where province in ('NM','内蒙');
update tabmembers set province='宁夏回族自治区' where province in ('NX','宁夏');
update tabmembers set province='青海省' where province in ('QH','青海');
update tabmembers set province='山东省' where province in ('SD','山东');
update tabmembers set province='陕西省' where province in ('SN','陕西');
update tabmembers set province='四川省' where province in ('SC','四川');
update tabmembers set province='西藏自治区' where province in ('XZ','西藏');
update tabmembers set province='新疆维吾尔自治区' where province in ('XJ','新疆');
update tabmembers set province='云南省' where province in ('YN','云南');
update tabmembers set province='浙江省' where province in ('ZJ','浙江');
update tabmembers set province='澳门特别行政区' where province in ('MO','澳门');
update tabmembers set province='香港特别行政区' where province in ('HK','香港');

展开阅读全文
打赏
1
0 收藏
分享
加载中
更多评论
打赏
0 评论
0 收藏
1
分享
返回顶部
顶部