By that I hope you mean there is an index on confinvitems.InvDetID _and_
confinvdet.ID
Yes, there is.
Could be a record in confinvitems that has an InvDetID that doesn't
exist in ConfInvDet. Check with something like:
SELECT InvDetID FROM confinvitems WHERE InvDetID NOT IN (SELECT ID FROM
Con
On Wed, 2006-07-26 at 08:58 -0400, Jesse wrote:
> I am trying to add a foreign key to one of my tables. When I execute the
> following SQL Code:
>
> ALTER TABLE `bpa`.`confinvitems` ADD CONSTRAINT `FK_confinvitems_1` FOREIGN
> KEY `FK_confinvitems_1` (`InvDetID`)
> REFERENCES `confinvdet` (`ID`)
Is this a InnoDB table.
Yes, sorry, I should have mentioned that. The rest of my tables are MyISAM,
and I discovered that it does not support Foreign Keys. So, I converted
these tables to InnoDB so that I can put the Foreign Keys in.
Thanks,
Jesse
--
MySQL General Mailing List
For list
Hi,
Is this a InnoDB table.
Thanks & Regards
Dilipkumar
- Original Message -
From: "Jesse" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Wednesday, July 26, 2006 6:28 PM
Subject: Adding Foreign Key Fails
I am trying to add a foreign key to one of my tables. When I execute the
followin
Thanks Mr Heikki
I try to remove ON DELETE SET DEFAULT
like this
mysql> alter table t_quiz_trivia add foreign key (client_id) references
t_client(client_id);
I found new error
ERROR 1216 (23000): Cannot add or update a child row: a foreign key
constraint fails
Finally i found the error
1. DDL o
Ady,
- Original Message -
From: "Ady Wicaksono" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 01, 2004 6:43 AM
Subject: Adding Foreign Key
mysql> alter table t_quiz_trivia add foreign key (client_id) references
t_client (client_id) on delete set defaul
Below DDL for t_quiz_trivia
CREATE TABLE `t_quiz_trivia` (
`quiz_id` int(11) NOT NULL auto_increment,
`quiz_name` text NOT NULL,
`quiz_keycode` varchar(255) NOT NULL default '',
`quiz_pil_jwb` varchar(255) NOT NULL default '',
`quiz_confirmation_msg` varchar(255) NOT NULL default '',
`quiz_er
Do you have an index on the client_id in the t_quiz table? Can you post
the ddl for t_quiz?
Ady Wicaksono wrote:
mysql> alter table t_quiz_trivia add foreign key (client_id)
references t_client (client_id) on delete set default;
ERROR 1005: Can't create table './smsserver/#sql-215d_11eff.frm'
(
