Dave's Brain

Browse - computer tips - mysql rename column

Date: 2009feb11

Q.  How do I rename a column in MySQL?

Q.  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);

Add a comment

Sign in to add a comment