On 1 March 2012 08:44, YAN HONG YE <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
