Code Forums - View Single Post - Setting a field equal to the row count of another table

redhead · 04-03-2006, 07:35 AM

He's talking about the FOREIGN activation ie:

Code:

CREATE TABLE foo (
    id INT NOT NULL auto_increment,
    UNIQUE id (id),
    PRIMARY KEY (id)
);
CREATE TABLE bar (
    id INT NOT NULL auto_increment,
    foo_id INT NOT NULL,
    UNIQUE id (id),
    PRIMARY KEY (id)
    FOREIGN KEY (foo_id) REFERENCES foo
);

04-03-2006, 07:35 AM	#3 (permalink)
redhead Newbie Join Date: Jun 2002 Location: Denmark Posts: 1,720	He's talking about the FOREIGN activation ie: Code: CREATE TABLE foo ( id INT NOT NULL auto_increment, UNIQUE id (id), PRIMARY KEY (id) ); CREATE TABLE bar ( id INT NOT NULL auto_increment, foo_id INT NOT NULL, UNIQUE id (id), PRIMARY KEY (id) FOREIGN KEY (foo_id) REFERENCES foo ); __________________ Don't worry Ma'am, We're university students, We know what We're doing. ----- If you pull the pin, Mr.Grenade would no longer be your friend. ----- 01000111 01101111 00100000 01000011 00100000 00100001