воскресенье, 24 января 2010 г.

MySql create table error 150

ERROR 1005 (HY000): Can't create table '******' (errno: 150)
This is the first error in the MySql InnoDB error codes page.
Cannot create table. If the error message refers to error 150, table creation failed because a foreign key constraint was not correctly formed. If the error message refers to error –1, table creation probably failed because the table includes a column name that matched the name of an internal InnoDB table.
In my case foreign key was not the same type as the referenced key, stupid, nasty error...

Комментариев нет: