InnoDB Delete On Cascade

2002-05-31 Thread Me
Hello People, I was just designing my database and I was planning to finally use the new feature provided by InnoDB : ON DELETE CASCADE So I tried the example : CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT

Re: InnoDB Delete On Cascade

2002-05-31 Thread Heikki Tuuri
, - INDEX par_ind (parent_id), - FOREIGN KEY (parent_id) REFERENCES parent(id) - ON DELETE CASCADE - ) TYPE=INNODB; Query OK, 0 rows affected (0.04 sec) mysql mysql insert into parent values(5); Query OK, 1 row affected