问题描述
错误代码:2013.在查询过程中失去与MySQL服务器的连接
我正在使用MySQL Workbench.另外,我正在运行一批插入件,总共约1000行(例如INSERT INTO mytable SELECT * FROM mysource1; INSERT INTO mytable SELECT * FROM mysource2;...mysource3...mysource4
乘以1000次),每批插入都花费相当多的时间,其中一些超过600秒.
I am using MySQL Workbench. Also, I am running a batch of inserts, about 1000 lines total (Ex. INSERT INTO mytable SELECT * FROM mysource1; INSERT INTO mytable SELECT * FROM mysource2;...mysource3...mysource4
multiplied 1000 times) Each batch takes a considerable amount of time, some of them, more than 600 seconds.
我如何配置工作台,使其在一夜之间继续工作,而又不停止且不丢失连接?
推荐答案
从现在开始不可用 Internet存档:
From the now unavailable internet archive:
关闭并重新打开MySQL Workbench.取消您先前的查询 可能正在运行,然后再次运行查询.
Close and reopen MySQL Workbench. Kill your previously query that probably is running and run the query again.
这篇关于MySQL Workbench:如何使连接保持活动状态的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!