(
- softwareID CHAR(20) NOT NULL,
- osName CHAR(20) NOT NULL,
- osRevision CHAR(20),
- INDEX (softwareID),
- FOREIGN KEY (softwareID) REFERENCES software (softwareID)
ON DELETE CASCADE ON UPDATE CASCADE,
- PRIMARY KEY (softwareID, osName
: mailing.database.mysql
Sent: Wednesday, June 11, 2003 9:03 AM
Subject: ON DELETE CASCADE ON UPDATE CASCADE
HI I'm not sure whether it's a bug or my configuration problem??
I have upgraded mysql from 3.23.53 to 4.0.12 so that the on update
cascade will work! then the I got mysql crash when I