Re: renaming

[Paul DuBois]

At 19:09 +0100 3/8/03, PaT! wrote:
>Hi,
>
>I need to change a column name.
>I wonder if there's any faster and simpler way to do it than:
>
>ALTER TABLE	table_name
>CHANGE old_column_name
>new_column_name create_clause;

No, that's how you do it.

>
>Thanks for the support.
>
>Patrizio Pino
>Roma - Italia
>
>sql
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread134288@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php