Manipulating MySQL column and table data

Often times I find it necessary to restructure data in my MySQL database for various reasons.  Usually it is because I have a better data structure in mind to give a site more functionality.  In order to perform the changes I need to either move data from one column to another or move the data [...]