Can’t update table ‘xxx’ in stored function/trigger because it is already used by statement which in...

最新推荐文章于 2022-07-01 09:03:04 发布
最新推荐文章于 2022-07-01 09:03:04 发布
阅读量985 收藏
点赞数
原文链接：http://www.cnblogs.com/FlFtFw/p/9574780.html
版权

MySQL: Solution for ERROR 1442 (HY000): Can’t update table ‘xxx’ in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

今天在做触发器时发生了这个错误

原因是在对某表操作时同时触发对该表插入

估计这在mysql不允许的

不可以把触发条件和触发动作归于一表

转载于:https://www.cnblogs.com/FlFtFw/p/9574780.html

2022-09-18 stonedb-subselect相关执行流程记录
悟世之路
09-18 311
mysql-subselect执行流程记录。
mysql1442错误_ERROR 1442 (HY000):because it is already used by statement which invoked this stored fun...
weixin_29149341的博客
02-18 1574
看到mysql的触发器，随手写了一个：mysql> create trigger t_ai_test-> after insert on test-> for each row-> begin-> update test set name='test_1';-> end;$Query OK, 0 rows affected (0.00 sec)OK没问题！my...
Can't update table 'aa' in stored function/trigger because it is already used by statement which inv
搬砖刘疯狂
10-29 4663
今天在使用触发器时，我是想在插入一条记录后更新改插入表中的某一条记录，触发器写好之后，当我插入一条数据时， 数据库报错：[Err] 1442 - Can't update table 'aa' in stored function/trigger because it is already used by statement which invoked this stored function/...
触发器在插入时更新此条新记录 错误it is already used by statement which invoked this stored functiontrigger的解决方法
编程人生的专栏
05-07 1万+
问题：create trigger InsertUser begin update users set user_power=[resource] where user_id=new.user_id; end;  当触发器执行过程中出现了错误：我使用的是Mysql5.0 Cant update table users in stored functio
MySQL触发器更新本表数据异常:Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this
热门推荐
老紫竹的专栏
02-02 3万+
 如果你在触发器里面对刚刚插入的数据进行了 insert/update, 则出现这个问题。因为会造成循环的调用. create trigger testbefore update on testfor each row  update test set NEW.updateTime = NOW() where id=NEW.ID;END应该使用set操作，而不是在触发器里使用 update
mysql 触发器错误 Can‘t update table in stored function/trigger because it is already used by state（已解决）
Late_whale的博客 作者：代码搬运工老李的二师兄
12-05 2万+
错误 Can’t update table ‘’ in stored function/trigger because it is already used by statement 产生原因 - 原因一： 触发器中使用了insert语句 示例表结构 定义一个插入触发器，new代表插入进来的值，new.sex则说明插进来的sex 插入触发器定义成功 执行插入语句 报错 1442 - Ca...
Error Code: 1442. Can‘t update table ‘xxx‘ in stored function/trigger because it is already used by
生而为人我很抱歉
02-08 1243
Error Code: 1442. Can’t update table ‘xxx’ in stored function/trigger because it is already used by statement which invoked this stored function/trigger. SELECT max(id) c FROM xxx; select add_test_data(299999); 调用mysql函数时，不能使用 (SELECT max(id) c FROM xxx)传
Can't update table 'psxt_user' in stored function/trigger because it is already used by statement wh
Brady74的博客
11-29 1750
Can't update table 'psxt_user' in stored function/trigger because it is already used by statement which invoked this stored function/trigger. MYSQL中触发器中不能对本表进行 insert ,update ,delete 操作，以免递归循
循环插入数据时报了Can't update table 'XXXX' in stored function/trigger because it is already used by statemen
G_whang的博客
08-06 2171
异常信息如下： Caused by: java.sql.SQLException: Can't update table 'XXXX' in stored function/trigger because it is already used by statement which invoked this stored function/trigger. at com.mysql.jdbc.SQ...
PostgreSQL源码分析——UPDATE
让我思考一下
07-01 3296
本文主要描述SQL中UPDATE语句的源码分析，代码为PG13.3版本。以 这条最简单的Update语句进行源码分析(dtea不是分区表，不考虑并行等，没有建立任何索引)，帮助我们理解update的大致流程。SQL流程如下：对应的代码： 解析部分——生成语法解析树UpdateStmt 关键数据结构：、、: 用户输入的update语句 由字符串会转为可由数据库理解的内部数据结构语法解析树 。执行逻辑在 中，需要理解flex与bison。gram.y中Update语法的定义： 解析部分——生成查询树Query
mysql 1442
最新发布
08-16
回答: ERROR 1442 (HY000): Can't update table 'xxx' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 是MySQL中的一个错误消息，表示在存储函数...
Mysql Error Code汇总
突破吧！次元壁
12-17 1625
Error Code: 1415. Not allowed to return a result set from a trigger 触发器中不允许返回结果为集合. 可能是变量设置时使用 select @var =select … from … 改为 select … from … into @var ...
PostgreSQL 源码解读（5）- 插入数据#4（ExecInsert）
08-06 1205
本文简单介绍了PG插入数据部分的源码，主要内容包括ExecInsert函数的实现逻辑，该函数位于nodeModifyTable.c文件中。 一、基础信息 按惯例，首先看看ExecInsert函数使用的数...
数据库触发器报错：Error Code: 1442. Can‘t update table in stored function/trigger because...
weixin_45828630的博客
11-10 8793
Error Code：1442.Can't update table 'orderdetails' in stored function/trigger because it is already used by statement which invoked this stored function/trigger. 报错原因（官方）：when you insert a record mysql is doing some lock stuff. you can't insert/update/dele
mysql can t update_MySql Error: Can't update table in stored function/trigger
weixin_39732534的博客
02-10 727
MySql Error: Can't update table in stored function/trigger because it is already used by statement which invoked this stored function/triggerI am running a MySQL Query. But when a new row is added fro...
mysql创建触发器错误提示：Can not update in stored function/trigger already used by statement invoked
yels303的专栏
02-25 3577
1、床架一个表user 定‘id’ 'num' 'age'三个字段，打算创建一个触发器，当修改/插入id、num时 age字段始终为id 和num 的乘积。 2、利用navicat for mysql 创建触发器：右击表名--->设计表--->触发器 定义sql语句为：update test  set NEW.age=NEW.id*NEW.num，如图所示： 3、创建好了以后当我们插
mysql从库触发器报错_mysql创建触发器报错
weixin_30588427的博客
02-02 535
报错：ERROR 1442 (HY000): Can't update table ‘yckj_company' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.在用mysql数据库的时候，想写一个触发器实现这个功能：在yckj...
mysql -- error code [1442]; Can't update table 'table_name' in stored function/trigger because it is already used by statement w
星星的技术专栏
04-10 1万+
mysql -- error code [1442]; Cant update table table_name in stored function/trigger because it is already used by statement which invoked this stored function/trigger 相关讨论：http://forums.mysql.c
mysql error 1442_mySQL 1442 错误
weixin_28831341的博客
01-27 1232
信息如下 ERROR 1442 (HY000): Can't update table 'event1' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.刚开始触发器定义如下create trigger event_trigge...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值