Date: 2009feb11 Keywords: sql Q. How do I rename a column in MySQL? A. As far as I know you have to specify the new type when renameing a column. So its like this:

ALTER TABLE <table> CHANGE <old-col> <new-col> <new-type>;

eg:

ALTER TABLE mytable CHANGE oldcol newcol VARCHAR(255);