MYSQL error 2006 when running an UPDATE based
get mysql error 2006 (server gone away) when trying to run the following SQL query:
UPDATE user_items
SET A = A + 1, B = B + 1
WHERE uid IN
(SELECT uid FROM user_achievements WHERE C >= 10)
I've heard that error 2006 happens when the queries are very heavy.
Would like some advice on how I could either the optimize the above query or bypass the error?
My database is running on MySQL 5.6.
Thanks.
Subject
Written By
Posted
MYSQL error 2006 when running an UPDATE based
November 19, 2023 09:41PM
November 26, 2023 03:33AM
November 28, 2023 08:53AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.