title: How to stop a running procedure in MySQL?
body: <p>I called a procedure in MySQL, but it is in an endless loop now! How to stop a running procedure in MySQL? The following is my procedure code：</p>
  
  <pre><code>drop procedure if exists my_proc; 
  DELIMITER $$
  CREATE PROCEDURE my_proc
  ()
  BEGIN
  DECLARE VAR INT;
  SET VAR=0;
  WHILE VAR&lt;10000
  DO
  INSERT INTO my_table () VALUES ();
  END WHILE;
  END; $$
  DELIMITER;
  
  CALL my_proc();
  </code></pre>