List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:May 22 2009 3:21am
Subject:Re: cannot alter table - rather urgent
View as plain text  
On Thu, May 21, 2009 at 11:06 PM, PJ <af.gourmet@stripped> wrote:
> I have a seemingly impossible situation. I cannot insert values into the
> tables and I cannot alter or delete the primary key (which should not
> exist) or delete the foreign keys nor remove the constraint. G search
> doesn't help.
>
> CREATE TABLE `book_categories` (
>  `bookID` smallint(6) unsigned NOT NULL,
>  `categories_id` int(2) unsigned NOT NULL,
>  PRIMARY KEY (`bookID`,`categories_id`),
>  KEY `fk_book_categories_books` (`bookID`),
>  KEY `fk_book_categories_categories` (`categories_id`),
>  CONSTRAINT `book_categories_ibfk_1` FOREIGN KEY (`book_id`) REFERENCES
> `book` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1
>
> Anybody out there still up? I'm rather desperate to fix this this evening...
> Thanks in advance.

We will need a little more information.  The table looks sound but is
clearly designed to link  2 other tables.  If you are failing to
insert or update, it seems likely that it is because the data is
absent in the foreign tables.  Can you confirm?  Because without that
forgeign data, these rows are pretty meaningless.

What is it you are trying to do?

-- 
 - michael dykman
 - mdykman@stripped

 - All models are wrong.  Some models are useful.
Thread
cannot alter table - rather urgentPJ22 May
  • Re: cannot alter table - rather urgentMichael Dykman22 May
    • Re: cannot alter table - solvedPJ22 May
      • Re: cannot alter table - solvedMichael Dykman22 May
        • Re: cannot alter table - solvedPJ22 May
          • Re: cannot alter table - solvedMichael Dykman22 May
  • Re: cannot alter table - rather urgentPeter Brawley22 May