delete action on mysql bt trigger

[sql]

Hi all, I want to what ever I delete on table1 also delete on transaction_log , the connecction with UserId , the following code is not work, I use Mysql 5.0

delimiter $$
CREATE TRIGGER DeleteTrigger
ON tabl1

FOR delete
BEGIN
delete transaction_log from transaction_log,
deleted where transaction_log.userId=deleted.User.Id;

END$$
delimiter ;
________
Og Kush Pictures

[MAK]

Try this on your test server.

delimiter $$
CREATE TRIGGER DeleteTrigger
ON tabl1

FOR delete
BEGIN
delete transaction_log from transaction_log,
deleted where transaction_log.userId=deleted.UserId;

END$$
delimiter ;