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
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
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
3 matches
Mail list logo