Skip to content

Instantly share code, notes, and snippets.

@tdomarkas

tdomarkas/interrupt_query.sql

Created December 11, 2015 10:34
Show Gist options
  • Save tdomarkas/e0dd7b1039b4c482bc83 to your computer and use it in GitHub Desktop.
Save tdomarkas/e0dd7b1039b4c482bc83 to your computer and use it in GitHub Desktop.
Download ZIP
Interrupts a MySQL query
Raw
interrupt_query.sql
DELIMITER $$
CREATE FUNCTION InterruptQuery(connection_id INT) RETURNS INT DETERMINISTIC
BEGIN
KILL QUERY connection_id;
RETURN 0;
END
$$
SELECT InterruptQuery(CONNECTION_ID()) $$
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment