Re: adding rows to InnoDB-child

[Felix Geerinckx]

scuba wrote:

> I've set up a parent-child relation with two INNODB tables. Updating and editing works great,
> but when I add a new row in my parent, the row is not added in the child.

It's seems you haven't totally understood what referential actions do. I advise you to (re)read http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html


> Is it actually possible to auto-add rows with foreign key relations and how does that work?

You can use a trigger (in MySQL 5).

--
felix
Please use BBCode to format your messages in this forum.