我不是很擅长sql而且我尝试了一些东西.考虑到代码的性能,将这5个更新语句组合成单个语句的最佳方法是什么?会是一个很大的帮助.非常感谢!
码:
----------------1
Update main_table
set a = (case
..some code.. end)
where condition_2;
----------------2
Update main_table
set b = (case
..some code.. end)
where condition_2
----------------3
Update main_table
set c = (select x from sec_table where conditon_1)
where condition_2
----------------4
Update main_table
set d = (select y from sec_table where conditon_1)
where condition_2
----------------5
Update main_table
set e = (select z from sec_table where conditon_1)
where condition_2