If you do something like a questionnaire, which will then filter (search), how best to store information?
age town rost ves cvet_volos razmer_obuvi etc. 22 1 154 45 2 36 ...
Or write somewhere the order of the columns and store everything in a row
id data 1 22-1-154-45-2-36
Columns will increase over time, that is, the items in the questionnaire will become more and more. Is there any column limit? And on request?
If you use the first option, the query will be:
ла ла ла WHERE ... AND... AND... AND... AND...
What is the limit here? And even if there is no limit, it will be very heavy requests? Or is MySQL fast and it will not be difficult for it to process a request with 100 conditions?
And in general, how best to do? What other ways are there? Right, so to speak :)