mysql触发器

create trigger tri_delete after delete on secm_user
for each row    
begin
delete from secm_message where Fname = old.user_name
delete from secm_goods where G_username =old.user_name
end

报错：check the manual that corresponds to your MySQL server version for the right syntax to use near 'delete from secm_goods where G_username =deleted.user_name end' at line 5

求高手指点

补充：old ;older;deleted都用了还是报这个错

答案：delete语句少了结束“；”

其他：老的表是old还是older，自己试试

上一个：MYSQL数据库导入.sql文件问题：.sql文件如下
下一个：JAVA 如何实现与MYSQL数据库建立连接