vinita vigine MURUGIAH [EMAIL PROTECTED] wrote:
Hello,
I'm using ver 4.0.12, checked for bugs in ver
4.0.12(http://bugs.mysql.com/search.php) but couldn't find this one.
Thanks for report, but I wasn't able to repeat Lost connection error on v4.0.16.
Many bugs were fixed since that time.
, 2003 6:32 AM
Subject: auto_increment with FOREIGN KEY UPDATE CASCADE courses Lost
connection to MySQL server
Hello,
I'm using ver 4.0.12, checked for bugs in ver
4.0.12(http://bugs.mysql.com/search.php) but couldn't find this one.
CREATE TABLE software (
softwareID VARCHAR(20
Hello,
I'm using ver 4.0.12, checked for bugs in ver
4.0.12(http://bugs.mysql.com/search.php) but couldn't find this one.
CREATE TABLE software (
softwareID VARCHAR(20) NOT NULL,
softwareName VARCHAR(100),
softwareVers VARCHAR(20),
installedDate DATE,
locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
- Original Message -
From: Daevid Vincent [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: 'Heikki Tuuri' [EMAIL PROTECTED]
Sent: Friday, September 12, 2003 4:01 AM
Subject: RE: Foreign key update and Error :: 1217 with v4.0.15
months ago I
wouldn't be able to do this huh ;-)
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 11:33 PM
To: Daevid Vincent; [EMAIL PROTECTED]
Subject: Re: Foreign key update and Error :: 1217 with v4.0.15
Daevid,
CONSTRAINT
Daevid Vincent [EMAIL PROTECTED] wrote:
Thanks Victoria for the pointer. I should have looked there first. Duh!
Now for the help... I tried:
ALTER TABLE rep_table ADD FOREIGN KEY (`rep_company_code`) REFERENCES
`company_table` (`company_code`) ON UPDATE CASCADE;
But get ERROR 1216:
I really appreciate your help with this.
Hmmm... So, while SET FOREIGN_KEY_CHECKS allowed me to ALTER the table, now
I can't UPDATE the company that has a rep with the same company_code
because:
Error :: 1217 :: Cannot delete a parent row: a foreign key constraint fails
UPDATE company_table SET
: mailing.database.myodbc
Sent: Thursday, September 11, 2003 9:10 PM
Subject: RE: Foreign key update and Error :: 1217
I really appreciate your help with this.
Hmmm... So, while SET FOREIGN_KEY_CHECKS allowed me to ALTER the table, =
now
I can't UPDATE the company that has a rep with the same
: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 12:45 PM
To: [EMAIL PROTECTED]
Subject: Re: Foreign key update and Error :: 1217
Daevid,
there is really one update you need to do first: upgrade to
MySQL-4.0.14.
http://www.innodb.com/ibman.html
I see there is a way to DELETE or NULL a cascade, but is there a way to
UPDATE?
Here's what I mean. Given these rough table schemas. I'd like to be able to
UPDATE the company_code in the company_table, and have it update the same
rep_company_code in the rep_table. Ie. So a company has a certain
: Wednesday, September 10, 2003 3:29 PM
To: [EMAIL PROTECTED]
Subject: Foreign key update?
I see there is a way to DELETE or NULL a cascade, but is
there a way to
UPDATE?
Here's what I mean. Given these rough table schemas. I'd like
to be able to
UPDATE the company_code in the company_table
Daevid Vincent [EMAIL PROTECTED] wrote:
I see there is a way to DELETE or NULL a cascade, but is there a way to
UPDATE?
ON UPDATE CASCADE, ON UPDATE SET NULL.
Look at:
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
Here's what I mean. Given these rough table
: Wednesday, September 10, 2003 2:40 PM
To: [EMAIL PROTECTED]
Subject: Re: Foreign key update?
Look at:
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
'
Subject: RE: Foreign key update?
Thanks Victoria for the pointer. I should have looked there
first. Duh!
Now for the help... I tried:
ALTER TABLE rep_table ADD FOREIGN KEY (`rep_company_code`) REFERENCES
`company_table` (`company_code`) ON UPDATE CASCADE;
But get ERROR 1216
14 matches
Mail list logo
