只想修改type='1001'的行数
update
agri.testNew
set
name =
(
case
when
type='1001'
then
'111111'
else
name
end
)
只想修改type='1001'的行数
update
agri.testNew
set
name =
(
case
when
type='1001'
then
'111111'
else
name
end
)