Re: MySQL + InnoDB + fereign keys

2002-01-09 Thread Heikki Tuuri
Ivan, currently InnoDB allows a NULL in the child column only if there is a NULL in the parent column. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ...

MySQL + InnoDB + fereign keys

2002-01-08 Thread IvanLatysh
Hi. I am using MySQL 3.23.44-MAX. with InnoDB I have create two tables (one of them parent, other child). All seems Ok. But when I am trying to insert new record into the table I am getting key violation. It happened when I am trying insert null value into field that have foreign key. (column c