changing column names?

How do I change column names? Just the name of the column. Everything else
stays the same. I found one way in the manual, but it requires re-supplying
the column type. This just can't be the best way, so what is?

Re: changing column names?

Tony Peardon wrote:
> How do I change column names? Just the name of the column. Everything else
> stays the same. I found one way in the manual, but it requires re-supplying
> the column type. This just can't be the best way, so what is?

http://dev.mysql.com/doc/refman/5.0/en/alter-table.html


//Aho