I have these lines
create table Singers(SingerName varchar(30),picture text,id int primary key auto_increment); create table Songs(id int primary key auto_increment,sid int,foreign key(sid) references Singers(id) ON DELETE CASCADE);
In situation I want to delete a Singer for example who has the id->1 from Singer's table
automaticaly to delete all his Songs from Song's table where sid has same value with id->1
but it does not work with me,,
I leave with this picture.