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.

Problem adding Foreign Key using Alter Table with existing MYSQL Database - can't add it! Help!

I have a production database where I have renamed several column's that are foreign keys. Obviously mysql makes this a …

mysql foreign-keys alter-table mysql-error-1005 mysql-error-1025
SQL - error code 1005 with error number 121

I'm running the following MySQL script (trimmed down), generated automatically by MySQL Workbench and I get the following error: Error …

mysql sql mysql-workbench mysql-error-1005
Resolving Error Code: 1005. Can't create table '' (errno: 150) Error

I am creating following three tables in mysql POSTMASTER ADVERTISEMENT CANDIDATEMAIN Here are the create statements POSTMASTER CREATE TABLE `postmaster` ( `…

mysql mysql-error-1005
MySQL error 150, cannot create table

I'm having trouble creating a table and I don't understand what's wrong. phpMyAdmin sets the error indicator next to the …

mysql mysql-error-1005
MySQL Error : #1005 - Can't create table (errno: 150) When I try create more than 1 FK

I have this table: CREATE TABLE IF NOT EXISTS `produtos` ( `id` int(11) NOT NULL auto_increment, `idcatprodutos` int(11) NOT NULL, `…

mysql foreign-keys mysql-error-1005
Error code 1005, SQL state HY000: Can't create table errno: 150

I'm trying to create a table but the script fails as soon as my netbeans errors the first table of …

mysql database mysql-error-1005
Adding foreign key on multiple columns

I'm trying to create a foreign key on two columns of a table to point to the same column of …

mysql foreign-keys mysql-error-1005
can't add foreign key in mysql?

I used MySQL workbench to add a foreign key in a table, but some strange error happened, this is the …

mysql foreign-keys mysql-error-1005
MySQL Error Code: 1005

I am trying to add foreign keys to my table but receiving this error. Error Code: 1005 Can't create table 'william.#…

sql mysql mysql-error-1005
Foreign Keys and MySQL Errors

I have the following script to create a table in MySQL version 5.1 which is to refer to 3 other tables. All 3 …

mysql mysql-error-1005