要用一条SQL实现查询,可以使用子查询和CASE语句来实现。以下是一个示例查询的SQL语句:

SELECT C_A83 AS S_C_A83, C_A84 AS S_C_A84, C_A85 AS S_C_A85, C_A86 AS S_C_A86, C_A87 AS S_C_A87, C_A88 AS S_C_A88, C_A90 AS S_C_A90, C_A91 AS S_C_A91, C_A92 AS S_C_A92, C_A93 AS S_C_A93, C_A94 AS S_C_A94, C_A96 AS S_C_A96, C_A97 AS S_C_A97, C_A5 AS S_C_A5, C_A6 AS S_C_A6, C_A7 AS S_C_A7, C_A8 AS S_C_A8 FROM t_d_nvfillform WHERE C_DELETED = 0 AND C_ID IN ( SELECT id FROM updateList );

请注意,updateList是一个参数,需要在执行SQL语句时将其传递给数据库

update t_d_nvfillform set S_C_A83 = C_A83 S_C_A84 = C_A84 S_C_A85 = C_A85 S_C_A86 = C_A86 S_C_A87 = C_A87 S_C_A88 = C_A88 S_C_A90 = C_A90 S_C_A9

原文地址: https://www.cveoy.top/t/topic/iXnY 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录