[Solved] which is better every user have a table or just a row [closed]

Question

Create a row for every user in a table. Details and other stuff should be in rows in other tables and then linked via primary key and foreign key.

If you create a table for every user it will take much space and not just that, you have to access a different table for every user, which makes it very complicated. In rows you can access a single user by the primary key of the corresponding row.

Accepted Answer

Create a row for every user in a table. Details and other stuff should be in rows in other tables and then linked via primary key and foreign key.

If you create a table for every user it will take much space and not just that, you have to access a different table for every user, which makes it very complicated. In rows you can access a single user by the primary key of the corresponding row.