afrashteh1
یک شنبه 08 دی 1387, 07:50 صبح
دوستان مشكل اين چيه هر كاري مي كنم بازم پيغام خطا مي ده .مي خوام از طريق كليد اصلي و خارجي بين جداول ارتباط برقرار كنم .
CREATE TABLE parent
(
companyn INT NOT NULL,
cname char(20),
PRIMARY KEY ( companyn )
) ENGINE = INNODB;
CREATE TABLE child
(
toyn int not null,
companyn int,
fee int,
count int,
primary key(toyn),
FOREIGN KEY (companyn) REFERENCES parent(companyn)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE = INNODB
CREATE TABLE parent
(
companyn INT NOT NULL,
cname char(20),
PRIMARY KEY ( companyn )
) ENGINE = INNODB;
CREATE TABLE child
(
toyn int not null,
companyn int,
fee int,
count int,
primary key(toyn),
FOREIGN KEY (companyn) REFERENCES parent(companyn)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE = INNODB