I need to update and rename a column name given from a '$_POST' var. At times I will also need to ADD a column name. You may either post a URL for good instructions, or tell me how so. I am not sure what version of MySQL we are running at work though ... we have PHP5 so I am guesssing we have latest version of MySQL too.
I am using this syntax:
ALTER TABLE staff CHANGE COLUMN address $_POST['var'] int(11)