In SQL / MySQL, are there reasons to not establish a one-to-one relationship in the same table?

Question

A one-to-one relationship can usually be stored in one table. Is there any reason not to store them in the same table?

Answer 1

The number and type of columns. There is a limit on the size of the columns in the table. See here . A maximum of 8,060 bytes per line.

Very large tables can also affect performance and are difficult to optimize and index well.

, . , 1 1 ( , , ). .

Answer 2

, " " http://onlamp.com/pub/a/onlamp/2001/03/20/aboutSQL.html

:

- , , .

Answer 3

, /, , , . .

Answer 4

" " "" - , http://onlamp.com/pub/a/onlamp/2001/03/20/aboutSQL.html , . / .

, , , . , , , ---.