MySQL: Can’t create table (errno: 150)

From the MySQL – FOREIGN KEY Constraints Documentation:

If you re-create a table that was dropped, it must have a definition that conforms to the foreign key constraints referencing it. It must have the correct column names and types, and it must have indexes on the referenced keys, as stated earlier. If these are not satisfied, MySQL returns Error 1005 and refers to Error 150 in the error message, which means that a foreign key constraint was not correctly formed. Similarly, if an ALTER TABLE fails due to Error 150, this means that a foreign key definition would be incorrectly formed for the altered table.

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Unknown column in ‘field list’ error on MySQL Update query
  3. Unknown column in ‘field list’ error on MySQL Update query
  4. MySQL – Operand should contain 1 column(s)
  5. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. MySQL create table if not exists and insert record only if table was created
  8. How do I use properly CASE..WHEN in MySQL
  9. How can I do a FULL OUTER JOIN in MySQL?
  10. MySQL query String contains
  11. What’s the difference between VARCHAR and CHAR?
  12. Case statement in MySQL
  13. How to declare a variable in MySQL?
  14. MySQL Cannot Add Foreign Key Constraint
  15. How to split the name string in mysql?
  16. How do I import an SQL file using the command line in MySQL?
  17. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  18. mysql Foreign key constraint is incorrectly formed error
  19. MySQL: Invalid use of group function
  20. How can I return pivot table output in MySQL?
  21. Compare dates in MySQL
  22. MySQL “WITH” clause
  23. MySQL Multiple Joins in one query?
  24. Error Code: 2013. Lost connection to MySQL server during query
  25. MySQL syntax for Join Update
  26. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  27. how to drop partition without dropping data in MySQL?
  28. MySQL combine two columns into one column
  29. Simple way to calculate median with MySQL
  30. Error 1046 No database Selected, how to resolve?
  31. MySQL Error 1264: out of range value for column
  32. Remove duplicate rows in MySQL
  33. How to SUM and SUBTRACT using SQL?
  34. Cast from VARCHAR to INT – MySQL
  35. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  36. How do you force mysql LIKE to be case sensitive?
  37. MySQL – UPDATE multiple rows with different values in one query
  38. How to create a MySQL hierarchical recursive query?
  39. ERROR 1148: The used command is not allowed with this MySQL version
  40. Insert into a MySQL table or update if exists
  41. How to round down to nearest integer in MySQL?
  42. MySQL starts with searching issue
  43. Query to convert from datetime to date mysql
  44. Is it possible to GROUP BY multiple columns using MySQL?
  45. MySQL error: key specification without a key length
  46. Best way to test if a row exists in a MySQL table
  47. Check if MySQL table exists without using “select from” syntax?
  48. MySQL equivalent of DECODE function in Oracle
  49. mysql update column with value from another table
  50. The used SELECT statements have a different number of columns
  51. How to delete from multiple tables in MySQL?
  52. How to copy a row and insert in same table with a autoincrement field in MySQL?
  53. Join vs. sub-query
  54. Alternative to except in MySQL
  55. Equivalent of explode() to work with strings in MySQL
  56. ROW_NUMBER() in MySQ
  57. MySQL OPTIMIZE all tables?
  58. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  59. MySQL – Get row number on select
  60. MySQL error: Unknown column in ‘where clause’
  61. How to truncate the text returned for a column in a MySQL query
  62. Using union and order by clause in mysql
  63. MySQL LIKE IN()?
  64. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  65. Moving database with phpMyAdmin
  66. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  67. Change sticky status of posts from phpMyAdmin
  68. Restose content from revisions – sql query
  69. Better way to migrate to server?
  70. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  71. DB prefix not updating
  72. How delete post_content records of specific category from phpmyadmin
  73. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  74. Find locations of all featured images of draft posts via SQL
  75. Update WooCommerce stock status with SQL query if stock value is greater than 0
  76. SQL query to change custom field in WordPress database
  77. Reset post IDs with all post meta
  78. An SQL query to find orphaned image attachments and their meta
  79. SQL command to export post_content from wp_posts using phpMyAdmin
  80. Want to delete woocommerce coupon in bulk from phpmyadmin based on published date
  81. SQL query to select dates between two dates
  82. When to use SELECT … FOR UPDATE?
  83. How do composite indexes work?
  84. How To Run A Github Repository?
  85. SQL Switch/Case in ‘where’ clause
  86. The backend version is not supported to design database diagrams or tables
  87. pg_ctl: no database directory specified and environment variable PGDATA unset
  88. Convert partially non-numeric text into number in MySQL query
  89. ‘CREATE PROCEDURE’ must be the only statement in the batch (Erro)
  90. Manually delete post from database
  91. How To Write An Inner Join With WP Query
  92. SQL query to get adjacent posts from search query
  93. How to import a Typo3 database to a wordpress site?
  94. Using AND and bracket grouping in SQL not working
  95. How can I convert everything from category X to have post format Link
  96. How to get database connection details without longing to cpanel in WordPress?
  97. How to Add or Change Post Title
  98. How to refactor DB queries for better TTFB in WordPress?
  99. query sql-table and change entities
  100. SQL Query Search page

Leave a Comment