触发更新应更新其他表SQLite33
CREATE TRIGGER update_accept
AFTER UPDATE OF toaddress ON tripletlist
FOR EACH ROW
BEGIN
UPDATE triplets
SET accepted = accepted + 1
WHERE senderip = inserted.senderip
AND fromaddress = inserted.fromaddress
AND toaddress = inserted.toaddress;
DELETE FROM tripletlist WHERE toaddress != "";
END;
在这里,我想更新三重列表时更新三胞胎,但是我只是在更新地址,我想使用(接受)+1更新三重态列表,以及在我刚刚更新到地址时将从address和senderip fromaddress和senderip。
CREATE TRIGGER update_accept
AFTER UPDATE OF toaddress ON tripletlist
FOR EACH ROW
BEGIN
UPDATE triplets
SET accepted = accepted + 1
WHERE senderip = inserted.senderip
AND fromaddress = inserted.fromaddress
AND toaddress = inserted.toaddress;
DELETE FROM tripletlist WHERE toaddress != "";
END;
Here I want to update triplets when triplist get updated but i am just updating to address and I want to update triplet list with (accepted) +1 and where will fromaddress and senderip while I am just updating to address.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论