![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
ly_490380384
这个作者很懒,什么都没留下…
展开
-
两个表之前的列操作
1.更新表CIS_ORGINFO_POSITION 的列cop_orgcode为cis_organinfo的列co_orgcode update cis_orginfo_position set cop_orgcode=(select tt.co_orgcode from cis_organinfo tt where tt.co_orgaddr=cop_orgname and row原创 2017-09-21 14:40:17 · 117 阅读 · 0 评论 -
myBatis批量插入和批量更新
一.批量插入1.oracle <insert id="batchInsert" parameterType="com.chinasofti.domain.ROrgPerson"> insert into ro_orgperson (personuuid,orguuid,isbelong) SELECT t.* FROM ( <foreac...原创 2018-12-18 16:55:37 · 342 阅读 · 0 评论