Search
 
SCRIPT & CODE EXAMPLE
 

SQL

bulk kill mysql processlist

SELECT CONCAT('KILL ',id,';') AS IDs
FROM information_schema.processlist 
WHERE TIME >10
AND command = "sleep"
Comment

PREVIOUS NEXT
Code Example
Sql :: key validation sql 
Sql :: oracle sleep 
Sql :: ver usuarios mysql 
Sql :: import mysql dump command line windows 
Sql :: second last highest id in sql 
Sql :: sql pick random row 
Sql :: update mysql centos 
Sql :: show user mysql 
Sql :: alter user root mysql 
Sql :: influxdb export to csv 
Sql :: show indexes mysql 
Sql :: alert table name mysql 
Sql :: mysql create database charset utf8mb4 
Sql :: get month of date sql 
Sql :: cross schema query oracle 2 users 
Sql :: select from one table where not on the other 
Sql :: pop sql insert value into 
Sql :: sql query to copy data from one column to another 
Sql :: operator does not exist: integer = text 
Sql :: mysql f# examples 
Sql :: mysql find non alphanumeric characters 
Sql :: get ddl materialized view oracle 
Sql :: c# get sql min date 
Sql :: oracle user quota unlimited 
Sql :: how to get weekday from old date in sql 
Sql :: oracle list service names 
Sql :: postgres list tables and row counts 
Sql :: ilike for date postgres 
Sql :: PL SQL MODIFY COLUMN NME 
Sql :: add user mysql wordpress 
ADD CONTENT
Topic
Content
Source link
Name
3+9 =