le-john thejohn

## mysql - kill all sleeping connections
SELECT GROUP_CONCAT('kill ',id SEPARATOR '; ') AS kill_list
FROM INFORMATION_SCHEMA.PROCESSLIST
WHERE command='Sleep';

## massInsertOrUpdate.php
/**
* Mass (bulk) insert or update on duplicate for Laravel 4/5
*
* insertOrUpdate([
*   ['id'=>1,'value'=>10],
*   ['id'=>2,'value'=>60]
* ]);
*
*
* @param array $rows
	SELECT GROUP_CONCAT('kill ',id SEPARATOR '; ') AS kill_list
	FROM INFORMATION_SCHEMA.PROCESSLIST
	WHERE command='Sleep';
	/**
	* Mass (bulk) insert or update on duplicate for Laravel 4/5
	*
	* insertOrUpdate([
	* ['id'=>1,'value'=>10],
	* ['id'=>2,'value'=>60]
	* ]);
	*
	*
	* @param array $rows