转眼间,这一年又结束了,再记录一点知识吧 同事说他有好多shapefile,想给每个shapefile添加一字段,并设置该字段的内容为shapefile文件名,想着用arcpy实现,于是有了下面的代码 import os import arcpy arcpy.env.workspace = r"F:\workspace\2017\other" fcs = arcpy.ListFeatureClasses() for fc in fcs: arcpy.AddField_managemen
将Portal设置页面中无用的内容删除: 在/portal-master/portal-impl/src/portal.properties文件中,有如下配置: # # Input a list of sections that will be included as part of the company # settings form. # company.settings.form.configuration=general,authentication,users,mail-host-n
select a,sys_guid() as b from mytable sys_guid() 是生成带分隔符(-)的GUID的自定义函数 查询B表的内容插入A表,MY_ID是A表的主键不可为空,因此需要B查询出来的数据增加一列并且赋值插入A insert into A (plan_id,ship_id,MY_ID) select plan_id,ship_id,sys_guid() as myMonthID from B