MySQL Forums
Forum List  »  Newbie

MYSQL error 2006 when running an UPDATE based
Posted by: ELMANDOUH MAHMOUD
Date: November 19, 2023 09:41PM

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.

Options: ReplyQuote


Subject
Written By
Posted
MYSQL error 2006 when running an UPDATE based
November 19, 2023 09:41PM


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.