N
N
Nikita Reshetnyak2020-07-28 12:00:57
SQL
Nikita Reshetnyak, 2020-07-28 12:00:57

Why do records double when adding FOREIGN KEY?

Good day, I added FOREIGN KEY to the plate to associate the menu with the type, but why the records are duplicated, maybe I added something wrong, or it should be so, Screenshots below.
5f1fe92087b3f406929348.png
5f1fe93416c32872117095.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
J
John Didact, 2020-07-28
@trjflash

Nothing is doubled up, it's just displayed like this... I don't know exactly why it's like this in phpMyAdmin, but it's like this... it's the same for me, like 1 - mainand main - 1But it would be worth referring, as I think, to id. And you will need to allocate less space, and edit without interference.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question