Mysql 强行Kill 连接

BEGIN
    
    DECLARE ErrorCount int default 0 ;
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET ErrorCount = 1;
    SET @Temp = 0;
    WHILE @Temp <= 1000000 DO
        KILL @Temp;
        SET @Temp = @Temp + 1;
    END WHILE ;
END

 

posted @ 2017-07-31 15:14  刘小吉  阅读(1225)  评论(0编辑  收藏  举报