MYSQL update the only x'th number in integer/bit datatype field

Question

I created 9 columns each which hold either a 0 or a 1 integer. They exist so that users can toggle certain things on and off. I'd like to get rid of these 9 columns and instead use only one column where i can hold 9 0's and 1's for the 9 things my users will toggle. So say i have 000000000 and my user decides to toggle the first function, how would an update query for table accounts and column toggletimers look like which would change the value to 100000000 and so on for the 9 numbers?

check out the user comments here: dev.mysql.com/doc/refman/5.1/en/bit-functions.html — Pepi
– Pepi, Commented Aug 6, 2015 at 14:03

JimmyB · Accepted Answer · 2015-08-06 14:18:33Z

1

You normally should not merge multiple fields into one in database design (violation of "1NF")
If you really want to, use the bitwise operations: update accounts set toggletimers = toggletimers | (1 << (9-1)) where ...

edited Aug 6, 2015 at 14:18

answered Aug 6, 2015 at 14:00

JimmyB

12.8k2 gold badges33 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

MYSQL update the only x'th number in integer/bit datatype field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related