March 21st, 2016, 11:27 AM
I can't insert data into my table!
I'm trying to insert this code into my Albums table on my MySQL database
But every time I try to I keep getting this error.
INSERT INTO `Albums` (`Albumid`, `Name`, `Numberoftracks`, `Artistid`, ]
`Genre`) VALUES (1, "Innuendo", 12, "Queen", "Rock");
I know it's something to do with my foreign key within the table, but I need to manually enter the foreign key because it's not auto-incremented.
1452 - Cannot add or update a child row: a foreign key constraint fails
(`b4014107_db1/Albums`, CONSTRAINT `Albums_ibfk_1` FOREIGN KEY (`Artistid`)
REFERENCES `Artist` (`Artistid`))
Here's the tables code. .
How do I fix this? I need to input data into the table.
CREATE TABLE `Albums` ( `Albumid` int(6) NOT NULL, `Name` varchar(50) NOT
NULL, `Numberoftracks` int(11) NOT NULL, `Artistid` int(6) NOT NULL,
`Genre` varchar(50) NOT NULL, PRIMARY KEY (`Albumid`), KEY `Artistid`
(`Artistid`), CONSTRAINT `Albums_ibfk_1` FOREIGN KEY (`Artistid`)
REFERENCES `Artist` (`Artistid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1
March 21st, 2016, 04:56 PM
you have artistid as INTEGER, so you can't insert an artist name into it
why do you say your artist table isn't auto_incremented?