No Triggers with MYSQL?????

[cyberbiker]

It seems the current version of MySQL does not support triggers.
Basically, the app that I am working on (Using SQL Server 7 Desktop) uses triggers to perform cascading deletes.
Is there a workaround of some type to perform cascading deletes using MySQL?

Terry (cyberbiker)

 

[vanekl]

create table tbl_a (
...

INDEX id_b_idx (id_b),

FOREIGN KEY (id_b) REFERENCES tbl_b(id_b)
ON DELETE CASCADE ON UPDATE CASCADE,

)
TYPE=INNODB;

 

[cyberbiker]

Thanks for the help.
As soon as it qits snowing here, I will get back to the book store and get down to studying MySQL in ernest.
Looks like MYSQL may be a solution to one of my major problems.
Sometimes I find it amazing what idle surfing while thinking will lead to.
As always these forums are full of good information.

Terry (cyberbiker)