Re: [sqlite] how much "case...when..." command?

2012-04-17 Thread Igor Tandetnik
YAN HONG YE wrote: > 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... > csse... > ... >CASE price2>80 WHEN 1 THEN 1 ELSE 0

Re: [sqlite] how much "case...when..." command?

2012-04-17 Thread Kit
2012/4/17 YAN HONG YE : > 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... > csse... > ... >    CASE price2>80 WHEN 1 THEN 1 EL

[sqlite] how much "case...when..." command?

2012-04-17 Thread YAN HONG YE
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... csse... ... CASE price2>80 WHEN 1 THEN 1 ELSE 0 END; in this command, I don't kn