CREATE TABLE publisher (
     publisherID int(11) NOT NULL auto_increment,
     publisherName varchar(32) NOT NULL default '',
     PRIMARY KEY(publisherID)
   ) TYPE=INNODB;


--
-- Table structure for table 'authors'
--
CREATE TABLE authors (
     authorID int(11) NOT NULL auto_increment,
     FirstName varchar(20) NOT NULL default '',
     LastName varchar(20) NOT NULL default '',
     PRIMARY KEY (authorID)
   ) TYPE=INNODB;




--
-- Table structure for table 'titles'
--
CREATE TABLE titles (
     isbn varchar(20) NOT NULL,
     title varchar(64) NOT NULL,
     copyright varchar(20) NOT NULL,
     publisherID int(11) NOT NULL,
     comments varchar(128) NOT NULL default '',
     publishers_publisherID INT,
     PRIMARY KEY(isbn),
     INDEX (publishers_publisherID),
     FOREIGN KEY(publishers_publisherID) REFERENCES publisher (publisherID)
   ) TYPE=INNODB;


--
-- Table structure for table 'authorsISBN'
--
CREATE TABLE authorISBN (
     authorID int(11) NOT NULL,
     isbn varchar(20) NOT NULL,
     authors_authorID INT NOT NULL,
     titles_isbn varchar(20) NOT NULL,
     INDEX (authors_authorID),
     FOREIGN KEY(authors_authorID) REFERENCES authors (authorID),
     INDEX (titles_isbn),
     FOREIGN KEY(titles_isbn) REFERENCES titles(isbn)
   ) TYPE=INNODB;


# example insert statements

INSERT INTO authors values (1,"H.M.","Deitel");

INSERT INTO titles values ("0130895601","Advanced Java 2 Platform How to Program",2001,1,"X",NULL);

INSERT INTO publisher values (1, "Printice Hall");



I am not able to use any insert statements with my authorISBN table. All the about insert statemetns works fine, but when i try to insert into authorISBN, i get an error:

Error: 1216: Can not add or update a child row: a foreign key constraint failure.


Can someone please create a database and add the tables and help me out here. MySQL manual does not explain this well. Thanx in advance.

-Nikolas

Nevermind, i fixed the problem. In authorISBN table, i just removed 'NOT NULL' exp from the Index declaration.

Nikolas