/SQL/Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")

Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")

SQLSTATE[HY000]: General error: 1005 Can't create table ``.`labels` (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table `labels` add constraint

//  To solve that first try to migrate another table.

Source: stackoverflow.com

Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")

-- make sure your [foreign key] column and [referenced] column same type or length.
-- look like this:-

create table users(
  id INT(11) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
  fullname VARCHAR(30) NOT NULL
);

create table user_addr(
  id INT PRIMARY KEY AUTO_INCREMENT,
  user_id INT(11) UNSIGNED NOT NULL,
  addr VARCHAR(150) NOT NULL,
  FOREIGN KEY (user_id) REFERENCES users(id)
);

-- [ user table:           id->int(11) unsigned ]-
--                                               |--> same data type with length
-- [ user_addr table: user_id->int(11) unsigned ]-

Similar codes

0 vote191 views3 answers
How to find all role in mysql
SQL
0 vote130 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes136 views2 answers
Postgresql get table names
SQL
2 votes144 views1 answer
Add new column not null sql server
SQL
11 votes151 views1 answer
Oracle export view ddl
SQL
1 vote129 views1 answer
Mysql show table character set
SQL
7 votes216 views1 answer
Oracle alter sequence restart start with
SQL
0 vote122 views1 answer
Update if else mysql
SQL
1 vote157 views1 answer
Psql search table
SQL
1 vote137 views1 answer
SQLSTATE[HY000] [2002]
SQL