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.

MySQL Create table with indexes error

Ok, so I am creating tables in MySQL with indexes and foreign keys. I use MySQL Workbench to create the …

Read More
mysql database-design mysql-error-1005
Foreign Key add fails in MySQL with Error Code 1005, number 150

So I'm attempting to add a new foreign key to one of my tables as such: ALTER TABLE `UserTransactions`.`ExpenseBackTransactions` …

Read More
mysql foreign-keys mysql-error-1005