Organization of data in sql databases?

Question

MySQL

Hello. It is necessary to understand how such a data structure is in sql storages. There is a table `users` and it has fields `field_1` `field_2` `field_3` and so on. The meaning is that the number of these fields is not limited, it can reach a large number, but within reasonable limits (`field_10000`). Each such field contains one digit. So what is the best way to implement such a structure? Or all the same to make restriction maximum on an amount of these fields?

Answer 1

if we are talking about postgresql - there is json, there are arrays.
And so - EAV.