更新时间:2021-11-19 21:56:45
有一种叫做第三范式的东西:使用它:)
There is something called the third normal form: use it :)
这对您来说基本上意味着,您需要将爱好与该表分开,创建一个包含可能的爱好的单独表,并在人员和爱好之间创建一个查找表.
Basically this means for you, you need to separate the hobbies from that table, create a seperate table with the possible hobbies and create a lookup-table between the people and the hobbies.
肮脏的方法是定义一个分隔符并将像 cricktet|football|painting 这样的东西插入到列中:但我真的不建议这样做!
The dirty way would be to define a seperator and insert smth like cricktet|football|painting to the column: but I would really not suggest to do that!