I'm trying to make table relations in mysql. I'm using graphical interface. I have index on my columns. Can someone tell me what's going on?
Asked
Active
Viewed 119 times
0
Bill Karwin
- 499,602
- 82
- 638
- 795
Svetlozar
- 937
- 1
- 9
- 22
-
Please provide snippets of the code SQL statement attempting to be executed. If there is no way for you to get that, then a more descriptive screenshot would be helpful. What I'm gathering from this is that you're attempting to add a row into a table that's utilizing a foreign key `id` from `quotes`, but there are no entries in `quotes` containing that `id`. – SteveK Apr 28 '18 at 00:00
-
Please provide sql statement – Mahesh Bhattarai Apr 28 '18 at 01:20
-
I don't wirte sql statement. I'm using. I'm using graphical interface. I just add new picture. – Svetlozar Apr 28 '18 at 05:22
-
Read this checklist of possible mistakes with foreign keys, it might help. https://stackoverflow.com/a/4673775/20860 – Bill Karwin Apr 28 '18 at 05:25