how to design the daily database user information section.
suppose the structure is as follows:
CREATE TABLE users(
`id` INT(11) PRIMARY KEY AUTO_INCREMENT,
`nickname` char(20) COMMENT "",
`age` INT(4) COMMENT "",
`phone` char(11) COMMENT "",
`password` char(100) COMMENT "",
....
`other` text COMMENT ""
)
the confusion lies in other
. Other information about the user is stored in it. Structures such as {"birthday": "2018-06-06", "place": "Shaanxi"}
.
what are the advantages and disadvantages of doing this? What a better design looks like. Thank you for your guidance!