MySQL Forums
Forum List  »  Quality Assurance

Circular Dependancy
Posted by: jaganmohan chandramohan
Date: March 02, 2011 01:02AM

hey in MYSQL,i have created a table with circular dependency in the same table...but i am not able to insert any data due to constraint restriction even though the value for foreign key attribute is NULL...

>>Like for example there is a table A with 2 attributes
sno(primary key) and
serial(foreign key referring to sno of the same table A).

its being created but cannot put data in to it even though the value for foreign key attribute is "NULL"......

It s happening in MYSQL i dunnno about the other databases...

{ENGINE IS INNODB}

what do i do???
Please help

Options: ReplyQuote


Subject
Views
Written By
Posted
Circular Dependancy
2195
March 02, 2011 01:02AM


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.