Thursday, August 27, 2009

MySQL Rename Multiple Columns

Category: — SkyHi @ Thursday, August 27, 2009
ALTER TABLE MEMBERS CHANGE name FirstName CHAR(100)
ALTER TABLE MEMBERS CHANGE age CurrentAge INT;


OR

ALTER TABLE MEMBERS CHANGE name FirstName CHAR(100), CHANGE age CurrentAge INT;

Reference: http://www.sitepoint.com/forums/showthread.php?t=422824