#
#添加触发器(当删除留言时,删除留言的回复)
#
create tigger tri_Tb_Message_delete
after delete
on tb_message
FOR Each row
BEGIN
delete from Tb_Reply where Message_Id in (select Message_Id from deleted);
End; #
#--添加存储过程(表名:Tb_Reply)
#insert
#
#
CREATE PROCEDURE pro_Tb_Reply_insert(
Message_Id int , --留言编号
Reply_Contents text, --回复内容
Reply_Time datetime='' --回复时间
)
BEGIN
Insert into Tb_Reply values(Message_Id,Reply_Contents,case is null (Reply_Time,'') when '' then getDate() when Reply_Time then Reply_Time end);
END;
给我帮我看看,貌似语法没有错,
#添加触发器(当删除留言时,删除留言的回复)
#
create tigger tri_Tb_Message_delete
after delete
on tb_message
FOR Each row
BEGIN
delete from Tb_Reply where Message_Id in (select Message_Id from deleted);
End; #
#--添加存储过程(表名:Tb_Reply)
#insert
#
#
CREATE PROCEDURE pro_Tb_Reply_insert(
Message_Id int , --留言编号
Reply_Contents text, --回复内容
Reply_Time datetime='' --回复时间
)
BEGIN
Insert into Tb_Reply values(Message_Id,Reply_Contents,case is null (Reply_Time,'') when '' then getDate() when Reply_Time then Reply_Time end);
END;
给我帮我看看,貌似语法没有错,
解决方案 »
- 帮我看看这个存储过程问题在哪里
- 关于postgresql中的锁
- 在已有字符串字段的基础上加唯一标示,该如何啊
- 高手帮我把这个sqlserver的 trigger改成mysql的吧, 急!
- 计算列的简单问题
- 帮忙!!ERROR 1064 (42000): You have an error in your SQL syntax;
- 如何用IP连接mysql数据库?mysql支持ADO么?
- 寻求一条sql语句
- 关于E-R图问题
- 谁能改我说一下mysql运行信息中哪几个比较关键!(我的mysql速度超慢,我想研究研究是怎么回事情)
- 求navicat premium 10.1.5.0注册码
- hibernate无主外键关系不能做连接查询么,直接在mysql敲命令可以啊
CREATE PROCEDURE pro_Tb_Reply_insert(
Message_Id int , --留言编号
Reply_Contents text, --回复内容
Reply_Time datetime='' --回复时间
)
BEGIN
Insert into Tb_Reply values(Message_Id,Reply_Contents,case is null (Reply_Time,'') when '' then getDate() when Reply_Time then Reply_Time end);
END$$
DELIMITER ;
after delete
on tb_message
FOR Each row
delete from Tb_Reply where Message_Id in (select Message_Id from deleted);
CREATE PROCEDURE pro_Tb_Reply_insert(
Message_Id int , --留言编号
Reply_Contents text, --回复内容
Reply_Time datetime='' --回复时间
)
Insert into Tb_Reply values(Message_Id,Reply_Contents,case is null (Reply_Time,'') when '' then getDate() when Reply_Time then Reply_Time end);
create tigger tri_Tb_Message_delete
after delete
on tb_message
FOR Each row
BEGIN
delete from Tb_Reply where Message_Id in (select Message_Id from deleted);
End;
//
create tigger tri_Tb_Message_delete
after delete
on tb_message
FOR Each row
BEGIN
delete from Tb_Reply where Message_Id in (select Message_Id from deleted);
End$$
delimiter;