re: Has somebody got an example of Foreign Keys

2003-02-13 Thread Egor Egorov
On Wednesday 12 February 2003 18:26, Ben Clewett wrote: > I am using 4.0.10-gamma-max-nt, with 100% innodb, and cannot get Foreign > Keys to create. > > The help files give this example: > > CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), > FOREIGN KEY (parent_id

Has somebody got an example of Foreign Keys

2003-02-12 Thread Ben Clewett
I am using 4.0.10-gamma-max-nt, with 100% innodb, and cannot get Foreign Keys to create. The help files give this example: CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE SET NULL ) TYPE=INNODB