MySQL Forums
Forum List  »  Newbie

table types and relations/constraints
Posted by: Michael Asbridge
Date: August 12, 2005 06:01PM


So I am new to all this but can some one tell me:

If I use myisam tables is it true that my relations constraints will not be enforced?

If I use Innodb tables I don't seem to be able to load (using mysqlimport) data into child tables (even if the parent table has valid values). I can get around this by using myisam but I am concerned that then constraints will not be enforced.

This seems a very unsatisfactory state of affairs. But maybe I am not understanding the situation?


Options: ReplyQuote

Written By
table types and relations/constraints
August 12, 2005 06:01PM

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.