不用建表用小代码代替案例 

SELECT * FROM TEP0002 T WHERE T.CODE_CLASS='PMLA00' AND T.CODE='batch' AND T.CODE_DESC_2_CONTENT='0'


UPDATE TEP0002 T SET T.CODE_DESC_2_CONTENT='0' WHERE T.CODE_CLASS='PMLA00' AND T.CODE='batch'

 

 

 

posted @ 2021-09-18 14:40  gitee1412  阅读(57)  评论(0)    收藏  举报