[mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 17. September 2003 01:35
An: Morten Gulbrandsen
Cc: [EMAIL PROTECTED]
Betreff: Re: AW: FOREIGN KEY() REFERENCES ON UPDATE CASCADE ON DELETE
RESTRICT
The first foreign key contraints in the following table definition mean
this:
Any record
-Ursprüngliche Nachricht-
Von: Toro Hill [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 16. September 2003 03:36
An: Morten Gulbrandsen
Cc: [EMAIL PROTECTED]
Betreff: Re: FOREIGN KEY() REFERENCES ON UPDATE CASCADE ON DELETE
RESTRICT
I believe that your ON UPDATE CASCADE clause should
PROTECTED]
Gesendet: Dienstag, 16. September 2003 03:36
An: Morten Gulbrandsen
Cc: [EMAIL PROTECTED]
Betreff: Re: FOREIGN KEY() REFERENCES ON UPDATE CASCADE ON DELETE
RESTRICT
I believe that your ON UPDATE CASCADE clause should be in the definition
for the PRODUCT and
CUSTOMER table rather
Dear Programmers,
At the end of this query,
I make a select * from the table product_order,
Which happens to be empty,
Why ?
Is something wrong with my insert statements please ?
I inserted something into the tables CUSTOMER and PRODUCT,
and I expected it to appear into the table
I believe that your ON UPDATE CASCADE clause should be in the definition for the
PRODUCT and
CUSTOMER table rather than the PRODUCT_ORDER table.
However, I don't think that it will work how you expect.
ON UPDATE CASCADE means that everytime you update a row in this table then all rows in
other