command coming out wrong mysql> mysql> mysql> alter table songs add foreign key(artist_id) references artist(id); ERROR 1452

command coming out wrong

   

Transcribed Image Text:

mysql> mysql> mysql> alter table songs add foreign key(artist_id) references artist(id); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (music. #sql-5b_10, COM EFERENCES'artist' ('id')) mysql> mysql> mysql> mysql> alter table songs add foreign key(artist_id) references artist(id); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (music. #sql-5b_10, COM EFERENCES'artist' ('id')) mysql>

Answer rating: 100% (QA)

It looks like you are attempting to add a foreign key constraint to the songs table that references the id column in the artist table but youre encoun... View the full answer