Does it make sense to create MySQL table relationships?

A

Andrey Raboy2015-10-25 19:30:21

MySQL

Andrey Raboy, 2015-10-25 19:30:21

The question has been tormenting for a long time: does it make sense to create relationships between tables (for example, in MySQL Workbench), if everyone uses JOIN?
I'm sitting creating a diagram in IDEF1X (MySQL Workbench) notation and I understand that the links will have to be removed, so what's the point?
Maybe I'm doing something or I'm not understanding it right?
How is a selection made from related tables? Or what is the difference in sampling from related and unrelated tables?
In the literature I have read, this issue is somehow bypassed ...
I hope that I have clearly formulated the question, I will be grateful for useful links.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

S

Soslan Aldatov, 2015-10-25
@raba

If you are talking about foreign keys, then they are needed to maintain referential integrity and will not simplify data sampling in any way.
Here it is well written.

A

Andrey Raboy, 2015-10-25
@raba

Yes, data integrity ... well, as I understand it, "cascading deletion" is provided by everyone using php, MySQL does not use this feature