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
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`)
ON DELETE CASCADE;
I get the error:
MySQL Error Number
ksono"
<[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 default;
ERROR 1005: Can't create table
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 (clien
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'
(
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' (errno:
150)
May i know what makes error ?
Here is the reference table
CREATE TABLE `t_client` (
`client_id` int(1
affected (0.00 sec)
mysql>
mysql>
mysql> insert into Leads(LeadNo) values (1);
Query OK, 1 row affected (0.00 sec)
mysql> insert into Leads(LeadNo) values (2);
Query OK, 1 row affected (0.00 sec)
mysql> insert into Leads(LeadNo) values (3);
Query OK, 1 row affected (0.00 sec
Hi all.
I just tried adding a foreign key constraint, and crashed MySQL ( 4.0.18 ).
I tried it again and crashed it again :(
The SQL I'm using is:
---
alter table Leads
add foreign key fk_LeadNo ( LeadNo ) references Prospects ( LeadNo );
---
The tables involved:
`Prospects` (
`LeadNo` mediumint(8
12 matches
Mail list logo
