On 1 March 2012 08:44, YAN HONG YE <yanhong...@mpsa.com> wrote: > I have a sqlite database named bb: > >> Name Price1 Price2 Slevel >> A1 23 231 NULL >> A2 22 12 NULL >> A3 21 223 NULL > > My question is: > I want to update culumn Slevel by function myfunc(): > > int myfunc(): > {int i=0; > if (price1 >12) > i++; > if (price1>30) > i++; > if (price2>20) > i++; > if (price2>30) > i++; > if (price2>80) > i++; > return i; > } >
For a table named bb: UPDATE bb SET Slevel = CASE price1>12 WHEN 1 THEN 1 ELSE 0 END + CASE price1>30 WHEN 1 THEN 1 ELSE 0 END + CASE price2>20 WHEN 1 THEN 1 ELSE 0 END + CASE price2>30 WHEN 1 THEN 1 ELSE 0 END + CASE price2>80 WHEN 1 THEN 1 ELSE 0 END; Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users