Software Venture Consulting
ToMarket

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

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



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

 Reference: MySQL Error 1005

Definition of 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

digg this | del.icio.us this

SURVEY: Which web technology do you prefer?

PHP         Cold Fusion
JSP         J2EE
ASP/.Net         Other
Lasso          

View the results


Lasso Master Class

The premiere class for Lasso 8 and Lasso Studio with FileMaker Server 7 Advanced, coming soon to a city near you. Click here.

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
derya

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
Shraddha
SolutionAnalysts

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

 

 

Click here for PHP/MySQL consulting services