| Bug #47885 | enlarge RENAME syntax | ||
|---|---|---|---|
| Submitted: | 7 Oct 2009 7:07 | Modified: | 7 Oct 2009 16:33 |
| Reporter: | Hans Ginzel | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DDL | Severity: | S4 (Feature request) |
| Version: | 5.4 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | rename column renaming | ||
[7 Oct 2009 7:41]
Valeriy Kravchuk
RENAME COLUMN part looks like a duplicate of bug #32497. Please, check.
[7 Oct 2009 14:32]
Hans Ginzel
Yes, but another syntax is suggested (ALTER TABLE). Do not confuse with table renaming using current syntax ALTER TABLE RENAME [TO] new_tbl_name;
[19 Jul 2011 11:44]
Valeriy Kravchuk
Bug #61906 was marked as a duplicate of this one.
Description: Please enlarge the reneame syntax: RENAME [ AND REPLACE ] { COLUMN | TABLE | VIEW | INDEX | FUNCTION | PROCEDURE | TRIGGER | SCHEMA | DTABASE | SERVER | EVENT } [ IF EXISTS ] old_name TO new_name; How to repeat: RENAME COLUMN old_name TO new_name;