Error Code: 1215. Cannot add foreign key constraint (foreign keys)

by

The most likely issue is this line:

FOREIGN KEY (classLeader) REFERENCES student(studentID),

The datatype of classLeader is VARCHAR(255). That has to match the datatype of the referenced column… student.studentID. And of course, the student table has to exist, and the studentID column has to exist, and the studentID column should be the PRIMARY KEY of the student table (although I believe MySQL allows this to be a UNIQUE KEY, rather than a PRIMARY KEY, or even just have an index on it.)

In any case, what’s missing here is the output from SHOW CREATE TABLE student;

There’s a datatype mismatch.

The classLeader VARCHAR(255) column cannot be a foreign key reference to studentID INT.

The datatypes of the two columns has to match.

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. How do I store large no.of small entries in Mysql?
  3. How should I resolve –secure-file-priv in MySQL?
  4. Location of my.cnf file on macOS
  5. How to do Inheritance Modeling in Relational Databases?
  6. What’s the difference between ” = null” and ” IS NULL”?
  7. Maximum number of records in a MySQL database table
  8. Swapping column values in MySQL
  9. What’s the difference between MyISAM and InnoDB? [duplicate]
  10. MySQL stored procedures use them or not to use them
  11. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  12. What’s the best database structure to keep multilingual data? [duplicate]
  13. How to increase MySQL connections(max_connections)?
  14. MySql views performance [closed]
  15. MySQL: LAST_INSERT_ID() returns 0
  16. How does MySQL Auto Increment work?
  17. Using reserved words in column names
  18. Calculating a Moving Average MySQL?
  19. How to get size of mysql database?
  20. Can I launch a trigger on select statement in mysql?
  21. How do you write a case insensitive query for both MySQL and Postgres?
  22. Strings as Primary Keys in MYSQL Database [closed]
  23. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  24. What is the difference between SQL and MySQL? [closed]
  25. mysql Failed to read auto-increment value from storage engine
  26. How to Get True Size of MySQL Database?
  27. Put MySQL database under version control?
  28. MySQL: Computed Column
  29. How do I make a MySQL database run completely in memory?
  30. How to recover just deleted rows in mysql?

Leave a Comment