Top "Mysql-error-1005" questions

If MySQL reports an error number 1005 from a CREATE TABLE statement, and the error message refers to error 150, table creation failed because a foreign key constraint was not correctly formed.

Error Code: 1005. Can't create table '...' (errno: 150)

I searched for a solution to this problem on the Internet and checked the Stack Overflow questions, but none of …

mysql foreign-keys mysql-error-1005
MySQL "ERROR 1005 (HY000): Can't create table 'foo.#sql-12c_4' (errno: 150)"

I was working on creating some tables in database foo, but every time I end up with errno 150 regarding the …

mysql foreign-keys mysql-error-1005
MySQL Foreign Key Error 1005 errno 150 primary key as foreign key

I'm making a small DataBase with MySQL Workbench. I have a main table, called "Immobili", which has a Primary Key …

mysql mysql-workbench mysql-error-1005
MySQL. Can't create table errno 150

I have to create a database with two tables in MySQL, but the script fails with errno 150 (foreign key problem). …

mysql mysql-error-1005
sql error errno: 121

CREATE TABLE `users` ( `UID` INT UNSIGNED NOT NULL AUTO_INCREMENT , `username` VARCHAR(45) NOT NULL , `password` VARCHAR(100) NULL , `name` VARCHAR(100) NULL , `…

mysql sql mysql-error-1064 mysql-error-1005
MySQL errorno 121

I'm getting this error in MySQL create. I'm doing: CREATE TABLE `blogReply` ( `Id` INT(24) NOT NULL AUTO_INCREMENT COMMENT 'Primary …

mysql foreign-keys mysql-error-1005
MySQL: Creating table with FK error (errno 150)

I've created a model with MySQL Workbench and am now attempting to install it to a mysql server. Using File &…

mysql foreign-keys innodb mysql-error-1005
Foreign key not working in MySQL: Why can I INSERT a value that's not in the foreign column?

I've created a table in MySQL: CREATE TABLE actions ( A_id int NOT NULL AUTO_INCREMENT, type ENUM('rate','report',…

mysql foreign-keys innodb mysql-error-1005
MySQL Foreign Key, Can't create table (errno: 150)

I am trying to build the database and tables for my system. But I found that if I don't add …

mysql foreign-keys mysql-error-1005
Mysql ERROR 1005 (HY000): Can't create table 'tmp' (errno: 13)

I'm Running Mysql on ubuntu 9.10, the process of Mysql is running as root, I'm using root account when logging to …

mysql ubuntu ubuntu-9.10 mysql-error-1005