将t_param_default,name为page_size的记录的value,如果value大于50,将值修改为50,否则不变
update t_param_default set value=
CASE
WHEN value > 50 THEN
'50'
ELSE
value
END
where name='page_size';
update t_param_default set value=
CASE
WHEN value > 50 THEN
'50'
ELSE
value
END
where name='page_size';