0

hey all
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.

Attachments errorMySQL.PNG 10.25 KB
2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by eawedat
0

Hi

obviously is your storage engine not innodb, for example it could be myisam. If so, then foreign-key definitions are useless. Indeed, mysql allow you to define foreign keys, however they won't be processed, kinda everlasting bug or so!

Except your are using storage engine innodb which know them.

It is always a good idea only to using innodb, here the policy "ON DELETE CASCADE" works fine and much more other things other storage engines lack of.

-- tesu

0

so you are saying that if I wanna use ON DELETE CASCADE I have to convert type of MySQL to InnoDB instead of myisam?

thanks

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.