table types and relations/constraints

[Michael Asbridge]

OK

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?

Michael