To find the specific error run this:
SHOW ENGINE INNODB STATUS;
And look in the LATEST FOREIGN KEY ERROR section.
The data type for the child column must match the parent column exactly. For example, since medicalhistory.MedicalHistoryID is an INT, Patient.MedicalHistory also needs to be an INT, not a SMALLINT.
Also, you should run the query set foreign_key_checks=0 before running the DDL so you can create the tables in an arbitrary order rather than needing to create all parent tables before the relevant child tables.
Related Posts:
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- Unknown column in ‘field list’ error on MySQL Update query
- Unknown column in ‘field list’ error on MySQL Update query
- MySQL – Operand should contain 1 column(s)
- MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL create table if not exists and insert record only if table was created
- How do I use properly CASE..WHEN in MySQL
- INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
- How can I do a FULL OUTER JOIN in MySQL?
- INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
- MySQL query String contains
- What’s the difference between VARCHAR and CHAR?
- Case statement in MySQL
- How to declare a variable in MySQL?
- How to split the name string in mysql?
- How do I import an SQL file using the command line in MySQL?
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
- mysql Foreign key constraint is incorrectly formed error
- MySQL: Invalid use of group function
- Can a foreign key be NULL and/or duplicate?
- How can I return pivot table output in MySQL?
- Compare dates in MySQL
- MySQL “WITH” clause
- MySQL Multiple Joins in one query?
- Error Code: 2013. Lost connection to MySQL server during query
- MySQL syntax for Join Update
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
- how to drop partition without dropping data in MySQL?
- When to use “ON UPDATE CASCADE”
- MySQL combine two columns into one column
- Simple way to calculate median with MySQL
- The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
- Error 1046 No database Selected, how to resolve?
- MySQL Error 1264: out of range value for column
- ERROR: there is no unique constraint matching given keys for referenced table “bar”
- Remove duplicate rows in MySQL
- How to SUM and SUBTRACT using SQL?
- Cast from VARCHAR to INT – MySQL
- SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
- How do you force mysql LIKE to be case sensitive?
- MySQL – UPDATE multiple rows with different values in one query
- How to create a MySQL hierarchical recursive query?
- ERROR 1148: The used command is not allowed with this MySQL version
- Insert into a MySQL table or update if exists
- How to round down to nearest integer in MySQL?
- MySQL starts with searching issue
- Query to convert from datetime to date mysql
- Is it possible to GROUP BY multiple columns using MySQL?
- MySQL error: key specification without a key length
- Best way to test if a row exists in a MySQL table
- Check if MySQL table exists without using “select from” syntax?
- MySQL equivalent of DECODE function in Oracle
- mysql update column with value from another table
- The used SELECT statements have a different number of columns
- How to delete from multiple tables in MySQL?
- MySQL: Can’t create table (errno: 150)
- How to copy a row and insert in same table with a autoincrement field in MySQL?
- Join vs. sub-query
- Alternative to except in MySQL
- Equivalent of explode() to work with strings in MySQL
- ROW_NUMBER() in MySQ
- MySQL OPTIMIZE all tables?
- MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
- MySQL – Get row number on select
- MySQL error: Unknown column in ‘where clause’
- How to truncate the text returned for a column in a MySQL query
- Using union and order by clause in mysql
- MySQL LIKE IN()?
- Cannot delete or update a parent row: a foreign key constraint fails
- Rename a column in MySQL
- Inserting data into a temporary table
- How to Select Top 100 rows in Oracle?
- CREATE VIEW must be the only statement in the batch
- SQL Server FOR EACH Loop
- SQL Query Where Field DOES NOT Contain $x
- How can I select the first day of a month in SQL?
- String or binary data would be truncated. The statement has been terminated
- Error converting data type varchar to float
- How to concatenate text from multiple rows into a single text string in SQL Server
- Count(*) vs Count(1) – SQL Server
- “You tried to execute a query that does not include the specified aggregate function”
- How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
- SQL Server dynamic PIVOT query?
- LEFT function in Oracle
- How to get the count of each distinct value in a column?
- Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
- How do I see the mysql query generated by get_posts( $args )?
- Better way to migrate to server?
- Making a query to the DB using same parameters of loop
- SQL command to convert all tags in lowercase?
- WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
- Why does changing Database Table Prefixes result in loss of content?
- WP MultiSite: Can’t select database error after changing to new domain
- Use variable in SQL statement
- Help me SELECT thumbnail from SQL and use
- I want to get on those users their meta value are like “AGENT” .. but this query is not working
- Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
- Replace Unwanted Space in Post Content URL
- If meta_key exists then don’t select this post?