axiom28 Posted January 6, 2017 Share Posted January 6, 2017 I am a nooby so some guidance would help. I am going through Larry's book on Chapter 6 where this subject of FOREIGN KEYS starts. I am trying the create the transactions table but get the error #1215 - Cannot add foreign key constraint This error came up using PHPMyAdmin, I tried using the command prompt which also failed, but the error message there was too vague, I rechecked and retyped the code several times with the same result. Is there possibly a typo in the book, what else could be wrong? I have been stuck here for a few days I need to move to the end of the chapter and more. Ian Link to comment Share on other sites More sharing options...
Larry Posted January 7, 2017 Share Posted January 7, 2017 Could you post the complete command you're running when you get this error and the complete error message you receive? Also, the version of MySQL in use. Link to comment Share on other sites More sharing options...
Recommended Posts