首先删掉旧的表,然后新建查询后执行下面语句。
SET GLOBAL max_allowed_packet = 1024 * 1024 * 1024;
SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet';
SET GLOBAL wait_timeout = 280000;
show global variables like '%timeout';
SET GLOBAL interactive_timeout = 280000;
show global variables like '%timeout';