RE: cannot add a foreign key

2005-02-18 Thread Sergei Skarupo
That's what it was... I was doing this in a test database and forgot that I changed some values manually before. Thanks, Sergei -Original Message- From: Ady Wicaksono [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 10:55 PM To: Sergei Skarupo Subject: Re: cannot

cannot add a foreign key

2005-02-18 Thread Sergei Skarupo
Hello everyone, I'm trying to add some foreign keys to the database... It works fine for one table but not for another. I need to make them both children of a third table. I'm using mysqld-max 4.0.16 on RedHat Linux. This is the statement that I ran: alter table signal_segments add foreign