ALTER TABLE book_categories
    ADD CONSTRAINT FK_BOOK_CATEGORIES2BOOKINFO FOREIGN KEY (book_id)
       REFERENCES BOOKINFO (book_id)
       ON DELETE CASCADE
       ON UPDATE RESTRICT;

    [mysqld-5.0.51a-24+lenny2]Can't create table './test_db/#sql-2186_227d8.frm' (errno: 150)

    SELECT * FROM book_categories
    WHERE book_id NOT IN (SELECT book_id from bookinfo)

CREATE TABLE bookinfo (
  book_id           integer               not null,
  vendor_book_id       integer,
  title_main           varchar( 254 ) not null comment 'название',
  .... (выкусил несущественное для сокращения)....
  primary key (book_id)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE book_categories (
  book_id              INTEGER                         NOT NULL,
  group_id             INTEGER                         NOT NULL,
  sort_order           INTEGER,
PRIMARY KEY (book_id, group_id)
)
COMMENT = 'связь книг с классификацией'
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;

SET FOREIGN_KEY_CHECKS= 0 ;

ALTER TABLE book_categories
    ADD CONSTRAINT FK_BOOK_CATEGORIES2BOOKINFO FOREIGN KEY (book_id)
       REFERENCES BOOKINFO (book_id)
       ON DELETE CASCADE
       ON UPDATE RESTRICT;

SET FOREIGN_KEY_CHECKS= 1 ;

SELECT * FROM book_categories
    WHERE (book_id+ 1 ) NOT IN (SELECT (book_id+ 1 ) from bookinfo)

__ InnoDB Buffer Pool __________________________________________________
 Usage           8.00M of   8.00M  %Used: 100.00 
Read hit       99.78%
Pages
  Free              0            %Total:   0.00
  Data            500                     97.66 %Drty:   0.00
  Misc             12                      2.34
  Latched           0                      0.00
Reads          65.48G   42.6k/s
  From file   143.78M    93.4/s            0.22
  Ahead Rnd   9784649     6.4/s
  Ahead Sql  63995308    41.6/s
Writes         20.93M    13.6/s
Flushes       418.29k     0.3/s
Wait Free           0       0/s

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock


[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-external-locking
key_buffer              = 32M
max_allowed_packet      = 32M
thread_stack            = 128K
thread_cache_size       = 8
query_cache_limit       = 2M
query_cache_size        = 32M
expire_logs_days        = 10
max_binlog_size         = 100M
skip-bdb



[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]

[isamchk]
key_buffer              = 16M

CREATE TABLE bookinfo (
  book_id           integer               not null,
  vendor_book_id       integer,
  title_main           varchar( 254 ) not null comment 'название',
  .... (выкусил несущественное для сокращения)....
  primary key (book_id)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE book_persons (
  person_id            integer                         not null,
  book_id              integer                         not null,
  role_id    integer not null comment 'роль',
  sort_order           integer                         not null,
primary key (book_id, person_id, role_id)
)
COMMENT = 'Связь Персоны-Книги-Роли'
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;


ALTER TABLE book_persons
   ADD CONSTRAINT FK_BOOK_PERS2BOOKINFO FOREIGN KEY (book_id)
      REFERENCES BOOKINFO (book_id)
      ON DELETE CASCADE
      ON UPDATE RESTRICT;

REPLACE INTO book_persons(
  person_id,
  role_id,
  book_id
)VALUES(
   269 ,
   296 ,
   5488 
)

SELECT * FROM bookinfo WHERE book_id =  5488 

SELECT @@sql_mode;

SET FOREIGN_KEY_CHECKS= 0 ;

ALTER TABLE book_persons
   ADD CONSTRAINT FK_BOOK_PERS2BOOKINFO FOREIGN KEY (book_id)
      REFERENCES BOOKINFO (book_id)
      ON DELETE CASCADE
      ON UPDATE RESTRICT;

SET FOREIGN_KEY_CHECKS= 1 ;