这种更新方法更好 更优?(本人倾向这种)
update tableA
set FieldA='A',
FieldB='B',
FieldC='C',
FieldD='D',
FieldE='E',
FieldF='F'
where ID='3'
还是下面这种更新方法 哪种更好 更优
update tableA
set FieldA='A'
where ID='3'
update tableA
set FieldB='B'
where ID='3'
update tableA
set FieldC='C'
where ID='3'
update tableA
set FieldD='D'
where ID='3'
update tableA
set FieldE='E'
where ID='3'
update tableA
setFieldF='F'
where ID='3'