自定义更新sql:
with t1 as (select acolumn,bid from a)
update b set b.bcolumn = (select acolumn from t1 where a.column = b.bcolumn) where b.id in (select bid from t1)
使用dao.execute(sql)执行如上sql报异常,查询没有传回任何结果,并且如上sql也没有正常执行
救救孩子吧
自定义更新sql:
with t1 as (select acolumn,bid from a)
update b set b.bcolumn = (select acolumn from t1 where a.column = b.bcolumn) where b.id in (select bid from t1)
使用dao.execute(sql)执行如上sql报异常,查询没有传回任何结果,并且如上sql也没有正常执行
救救孩子吧