What! What?

Inspired by a great talk I attended today by Ryan Sims I've been swoting up on the Dreyfus model which defines a model for new skill acquisition. Thinking about this model while acquiring new skills allows you to focus on what you need to do to get to the next level (eventually Expert), rather than just simply spending time with a new technology/subject which I all too often do. Its about 'learning smartly'.

innotop is a fantastic tool to investigating what's going on live inside your MySQL server. Use it to spot locks, deadlocks, long running queries, buffer sizes, replication status

I've been using the HAVING clause to simplify my SQL queries. It allows you to specify a condition for an aggregate function used in the SELECT list (doing so in the WHERE clause is illegal).

So to find the politicians who are receiving a total of more than $50,000 of expenses

	
		SELECT politician, SUM(payment) 
		FROM expences 
		GROUP BY politician 
		HAVING SUM(payment) > 50000;	

Nice!