Conditional value in sqlite column

Question

I have two integer columns in my sqlite table: a and b. I need to create a third column, c, which should contain either Y if a+b mod 2 == 1 or N if the previous condition is not satisfied. I am not sure how to define such a column with a conditional value in my query.

Gordon Linoff · Accepted Answer · 2014-05-17 12:44:31Z

12

You can do this readily in a query:

select a, b, (case when (a + b) % 2 = 1 then 'Y' else 'N' end) as col3
from table t;

You can do this in an update statement as well:

update t
    set col3 = (case when (a + b) % 2 = 1 then 'Y' else 'N' end) ;

You need to be sure that col3 exists. You can do that with alter table:

alter table t add column col3 int;

edited May 17, 2014 at 12:44

answered May 17, 2014 at 12:39

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

linkyndy Over a year ago

Thank you for pointing me a clear approach to this! I'll need to get a better grasp of sqlite's capabilities...

Collectives™ on Stack Overflow

Conditional value in sqlite column

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related