[SOLVED] change column names

[Lodius2000]

is there a way I can quickly change the name of a few columns of a mysql table? I made the table a long time ago, and dont really like my naming convention for some of the fields

 

thanks

[btherl]

You can use the ALTER TABLE command.  Or an admin interface like mysqladmin should be able to do this also.

[Lodius2000]

so something like

 

SELECT tablename ALTER TABLE CHANGE old-col-name new-col-name

 

would that be it?

[btherl]

You don't need the select.  alter table is a command on its own.  Try this:

 

ALTER TABLE t CHANGE COLUMN old_name new_name INTEGER

 

Make sure you give the same type as the column was before.  The docs say this:

 

You can rename a column using a CHANGE old_col_name new_col_name column_definition clause. To do so, specify the old and new column names and the definition that the column currently has. For example, to rename an INTEGER column from a to b, you can do this:

 

ALTER TABLE t1 CHANGE a b INTEGER;

 

 

 

[Lodius2000]

ahh thanks, didnt know alter table allowed a name after it

 

thanks