Efficient Way to store a table of checkbox data into MySQL database?
Efficient' is a slightly ambiguous term. In terms of storage requirements, the most efficient solution would be a bit-field - but that will result in very inefficient queries - and will be difficult to adapt to changes in the data model. If it were me I'd just normalise it.
You can use as a serialize or JSON like {a1:0, a2:1,a3:0} . When select this data ..decode it again... I prefer this way...
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
In mysql, what is an efficient way to get only rows in a table by a distinct value in one of that table's columns?
Inserting data from one mysql table into another mysql table using a form?
Efficient php code to insert array data into mysql table?
Strange data swapping error occurs when I attempt to update rows in my table from another table in MySQL database?
Most Efficient MySQL query to update a table from identical memory table?
The most efficient method storing voting data in a MySQL database (like StackOverflow)?