Mysql constraint cannot add

Question

I have a problem in mysql code. Not allow me to import sql file and give me this error " #1215 - Cannot add foreign key constraint "

I have no ideea what to do. I searched here, i tried some examples like this: MySQL error: Cannot add foreign key constraint? but no succes.

Why did you removed all the SQL code from your question? Now this question & answer is useless as it makes no sense. — Dijkgraaf
– Dijkgraaf, Commented Jun 14, 2015 at 21:04
it's code from my license... i dont want to be acused of plagiarism. — Octavian
– Octavian, Commented Jun 14, 2015 at 21:54

muratgu · Accepted Answer · 2015-06-14 20:09:59Z

1

You need to use all of the primary key columns on your FK references.

FOREIGN KEY (`an`)
REFERENCES `studenti` (`an`)

should be

FOREIGN KEY (`idstud`, `an`)
REFERENCES `studenti` (`idstud`,`an`)

Of course, then you need to add idstud to your teste table.

answered Jun 14, 2015 at 20:09

muratgu

7,3213 gold badges27 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1