MySQL Forums
Forum List  »  InnoDB

Re: ERROR 1005: Can't create table (errno: 121) Help
Posted by: Prabhakar Kasi
Date: June 06, 2007 07:37AM

This error occurs when a foreign key constraint for the same field exist.
For Me I had product table and subcattable.
In subcattable I had a foreign key constraint of cascade delete on productid in product table.
I renamed both the tables and tried to create fresh product table and subcattable. Product table was created properly but subcattable gave the error Can't create table (errno: 121)

I deleted the renamed subcattable. Then it was fine

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR 1005: Can't create table (errno: 121) Help
9457
June 06, 2007 07:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.