名字和姓分开还是放在数据库中,哪个更好?

时间:2021-07-26 07:07:22

What would be better to create on the database on the table users?

在表用户的数据库上创建什么更好?

  • id
  • id
  • username
  • 用户名
  • password
  • 密码
  • fullName
  • fullName

or

  • id
  • id
  • username
  • 用户名
  • password
  • 密码
  • firstName
  • firstName
  • lastName

I've been trying to find this but the only thing I find about this is "how names are different in different countries". Which is more usefull and better to put in a database?

我一直在寻找这个,但我唯一发现的是“不同国家的名字是如何不同的”。哪个更有用,更适合放在数据库中?

1 个解决方案

#1


2  

Personally, I believe it is a lot easier to concatenate first and last names together than it is to parse a string that may have one or more of these. The result would be the same, but more organized.

就我个人而言,我相信将第一个和最后一个名字连接在一起比解析一个可能有一个或多个这样的字符串要容易得多。结果是一样的,但更有条理。

#1


2  

Personally, I believe it is a lot easier to concatenate first and last names together than it is to parse a string that may have one or more of these. The result would be the same, but more organized.

就我个人而言,我相信将第一个和最后一个名字连接在一起比解析一个可能有一个或多个这样的字符串要容易得多。结果是一样的,但更有条理。