MySQL Global Vars wait_timeout & max_connections

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/37/mysql-global-vars-wait-timeout-max-connections

MySQL Relationships & Foreign Keys

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/36/mysql-relationships-foreign-keys

How I love previously coded code

I'm currently writing more software, and every time I have to do something which makes me sit back and think "hmm..now how is best to do this", I remember I've already been here before, and thanks to my magpie like abilities tendencies, I've got all the code ready for consumption.

So, dear past me, thank you for all the code you've written, you're helping make my tomorrow just that little bit easy. Thank you for your session handler class and for your listview sorting methods and for all the time you spent on SQL.

Regards,
Present Me

MySql Version "Correlated Sub-Queries and Group By Unions"

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/27/mysql-version-correlated-sub-queries-and-group-by-unions

SQL Correlated Sub-Queries and Group By Unions

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/21/sql-correlated-sub-queries-and-group-by-unions

SQL Get most recent records with group by

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/20/sql-get-most-recent-records-with-group-by

SQL INSERT with WHERE clause

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/13/sql-insert-with-where-clause

Get Average using SQL

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/9/get-average-using-sql

Sql threesomes.. Two foreign keys, one primary key

This blog post has moved:

http://www.adamkdean.co.uk/blog/read/8/sql-threesomes-two-foreign-keys-one-primary-key