Bug #61906 RENAME COLUMN

• Submitted: 19 Jul 2011 8:26
• Modified: 19 Jul 2011 11:43
• Reporter: Hans Ginzel
• Status: Duplicate
• Category: MySQL Server: DDL
• Severity: S4 (Feature request)
• Version: 5.1
• OS: Any
• CPU Architecture: Any
• Tags: rename column

[19 Jul 2011 8:26] Hans Ginzel

Description:
Please add commands
RENAME COLUMN [db.]table.column TO new_name; -- Oracle
and
ALTER TABLE [db.]table RENAME COLUMN old_name TO new_name;
.

How to repeat:
ALTER TABLE a CHANGE id i int;
-- Why to define the type, comment, not null, etc again?

[19 Jul 2011 8:32] Hans Ginzel

It is copy of #47885.

[19 Jul 2011 11:43] Valeriy Kravchuk

This is a duplicate of bug #47885. That feature request is verified and accepted as reasonable. No need to report it again.