Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages

Shopping Cart
Shopping Cart


Free Newsletter


Privacy Policy

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.


 Reference: MySQL Error 1005

MySQL Error 1005 : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Can't create table '%s' (errno: %d)

FileMaker Error Codes

Lasso Error Codes

MySQL Error Codes

Windows System Errors

About this database
This is a free public resource. It is unmoderated and operates on the "public virtue" system. I hope you find it useful!

User Contributed Notes

2010-07-07 02:02:21

MYSQL always gives this error while trying to add foreign keys.Isn't there an easy way to add foreign keys?

This is my note and I want to edit it | Report an inappropriate comment

2013-08-05 06:15:10

If you’re using referential integrity on MySQL, you can easily run into this error with the InnoDB engine. It frequently seems to occur with an ALTER TABLE statement. It can mean many things but typically it means the data types don’t match between the foreign key and primary key column. Likewise, it can mean one of the column data types disagrees in a multiple-column foreign to multiple-column primary key constraint.

This is my note and I want to edit it | Report an inappropriate comment

+ Add your own note