I needed to modify some columns on a MySQL table today and found myself having to lookup the syntax and found this article which explains it.