MySQL Forums
Forum List  »  MySQL Workbench

Re: lost connection to mysql server during query 30.000 sec
Posted by: leonid lecksunov
Date: September 08, 2020 09:04PM

I have checked the query result. The query was executed correctly.
Now i have tried directly shell action.
$ sudo mysql -u user -p
mysql> use nvm;

Database changed

mysql> UPDATE `nvm`.`payment_doc` SET `partition_id` = 0;
Query OK, 219629 rows affected (22,54 sec)
Rows matched: 220872 Changed: 219629 Warnings: 0

mysql> UPDATE `nvm`.`payment_doc` SET `partition_id` = `confirmation_sign`;
Query OK, 219629 rows affected (12,42 sec)
Rows matched: 220872 Changed: 219629 Warnings: 0

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: lost connection to mysql server during query 30.000 sec
53
September 08, 2020 09:04PM


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.