首页Can't update table 'test_trigger' in stored function/trigger because it is already used by statement...

Can't update table 'test_trigger' in stored function/trigger because it is already used by statement...

时间: 2023-06-27 12:02:51 浏览: 135

Article_Src.zip_.src.zi_DNS Csharp_Everything and More_dns resol

The main core of DNS resolving is the resolver . This class wraps queries into DNS packets and sends them to any DNS server. The response is then decoded into some useful information (at least for programmers, or for me in special -)). All my DNS stuff uses the namespace Heijden.DNS. Don t change it in your applications, it gives me some comfort knowing my name is stored in some nice other projects. Don t forget to let me know. Because I don t want to go immediately into details in this article, I only show the usage of the resolver component to warm you up. As the best way to do this, I have built a Dig class which acts like the good-old-Unix-style dig. Its acts like dig, but it is not a complete dig implementation. It does, however, do everything you want it to, presenting the output in more or less the same format. This is the outline of the Dig class:

这个错误是因为在触发器或存储函数中，你正在尝试更新一个已经被当前语句使用的表。在MySQL中，当你在一个语句中使用了一个表，该表就被锁定，直到该语句结束。如果你尝试在同一个语句中更新锁定的表，就会出现这个错误。解决方法是使用不同的语句来更新表。例如，你可以在触发器或存储函数中使用INSERT INTO ... ON DUPLICATE KEY UPDATE语句来更新表，而不是UPDATE语句。这样就可以避免出现这个错误。另外，你也可以使用临时表来避免这个问题。

阅读全文