我可以在社交网站中为每个用户创建每个表吗？-Canicreateeachtableforeachuserinmysocialnetworkingsite?

6  

This is not the way you want to do it.

这不是你想要的方式。

What you want to do is have a table (perhaps called 'users') that contains one row for each user that registers. Creating a new table for each user is completely pointless and would cause terrible performance.

你想要做的是有一个表(可能称为'用户'),每个用户注册一行。为每个用户创建一个新表是完全没有意义的,会导致糟糕的性能。

Maybe something like this:

也许是这样的:

 TABLE users
   - username AS VARCHAR(255)
   - password AS VARCHAR(255) (use a hashed password, of course)
   - ...

Then when a user registers, simply insert the information they provide into the users table as a new row.

然后,当用户注册时,只需将他们提供的信息作为新行插入到users表中。

2  

That would be massive overkill. You should probably read up on database design (start with normalisation, but don't overdo it). Then write down what you want to save for each user, and think about how to save it without saving data double.

这将是巨大的矫枉过正。您应该阅读数据库设计(从规范化开始,但不要过度)。然后记下您要为每个用户保存的内容,并考虑如何在不保存数据的情况下保存它。

But I'm pretty sure a table-per-user is not an option for this.

但我很确定每个用户的表不是一个选项。