MySQL. Can’t create table errno 150

by

table1.field1 has no index defined on it.

It is required to place a FOREIGN KEY constraint on field1.

With this:

 CREATE  TABLE IF NOT EXISTS `testdb`.`table1` (
   `id` INT UNSIGNED NOT NULL ,
   `field1` VARCHAR(50) NULL ,
   KEY ix_table1_field1 (field1),
   PRIMARY KEY (`id`) )
 ENGINE = InnoDB;

Everything should then work as expected.

More Related Contents:

  1. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  2. MySQL Foreign Key Error 1005 errno 150 primary key as foreign key
  3. MySQL “ERROR 1005 (HY000): Can’t create table ‘foo.#sql-12c_4’ (errno: 150)”
  4. MySQL errorno 121
  5. Recreating a query using INNER JOIN? [duplicate]
  6. Create a Cumulative Sum Column in MySQL
  7. MySQL: Enable LOAD DATA LOCAL INFILE
  8. Equivalent of explode() to work with strings in MySQL
  9. 1064 error in CREATE TABLE … TYPE=MYISAM
  10. mysql select dynamic row values as column names, another column as value
  11. Access denied for user ‘root’@’localhost’ (using password: YES) (Mysql::Error)
  12. Setting up MySQL and importing dump within Dockerfile
  13. MySQL DELETE FROM with subquery as condition
  14. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  15. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  16. Simple Random Samples from a Sql database
  17. node.js mysql error: ECONNREFUSED
  18. Relational database design multiple user types
  19. Checking multiple columns for one value
  20. Delete query not working in mysql
  21. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  22. Not unique table/alias
  23. MySQL GROUP BY DateTime +/- 3 seconds
  24. MySQL foreign key to allow NULL?
  25. MySQL : When stored procedure parameter name is the same as table column name
  26. Dynamic conversion of string into column name. MySQL
  27. Does a UNIQUE constraint automatically create an INDEX on the field(s)?
  28. MySQL: Can I do a left join and pull only one row from the join table?
  29. How do I write an SP in phpMyAdmin (MySQL)?
  30. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys

Leave a Comment