dtt3399 2013-11-07 18:13
浏览 35

MySQL触发失败的更新调用插入

I would like to have a Trigger on a failed Update which will insert into the same table.

If possible, I would prefer avoiding any additional php and SELECT due to performance.

So I thought of something like this for the TRIGGER:

CREATE TRIGGER `onChunksUpdate` AFTER UPDATE ON  `chunks` 
FOR EACH ROW 

IF ROW_COUNT() = 0 
THEN INSERT INTO chunks( scopeX, scopeY, targets ) 
VALUES (NEW.scopeX, NEW.scopeY, NEW.targets);
END IF ;

And the executed Update statement(php):

UPDATE chunks SET targets = CONCAT(targets, ',{$id}') WHERE scopeX={$chunkX} AND scopeY={$chunkY}

Furthermore I am not sure, wether a failed update call would still execute a TRIGGER of the time AFTER.

Thanks for any help, I googled very much to find any help but I found nothing.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 echarts动画效果失效的问题。官网下载的例子。
    • ¥60 许可证msc licensing软件报错显示已有相同版本软件,但是下一步显示无法读取日志目录。
    • ¥15 Attention is all you need 的代码运行
    • ¥15 一个服务器已经有一个系统了如果用usb再装一个系统,原来的系统会被覆盖掉吗
    • ¥15 使用esm_msa1_t12_100M_UR50S蛋白质语言模型进行零样本预测时,终端显示出了sequence handled的进度条,但是并不出结果就自动终止回到命令提示行了是怎么回事:
    • ¥15 前置放大电路与功率放大电路相连放大倍数出现问题
    • ¥30 关于<main>标签页面跳转的问题
    • ¥80 部署运行web自动化项目
    • ¥15 腾讯云如何建立同一个项目中物模型之间的联系
    • ¥30 VMware 云桌面水印如何添加