日期:2014-05-18 浏览次数:20552 次
insert into a (feiyong) select case when zijin * feilv <5 then 5 else zijin * feilv end
------解决方案--------------------
insert into a (feiyong) select case when zijin * feilv < 5 then 5 else zijin * feilv end
------解决方案--------------------
insert into a (feiyong) values(case when zijin * feilv<5 then 5 else zijin * feilv end)