Bug #31096 misleading information in alter table docs
Submitted: 19 Sep 2007 12:54 Modified: 19 Sep 2007 13:23
Reporter: jan matejka Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: ALTER TABLE, change column, documentation

[19 Sep 2007 12:54] jan matejka
Description:
i needed to change column name so i went here http://dev.mysql.com/doc/refman/5.0/en/alter-table.html and according to
ALTER [IGNORE] TABLE tbl_name CHANGE [COLUMN] old_col_name column_definition
i thought the command is "alter table table_name change new_column_name old_col_name column_definition". I asked a colleague and he thinks the same thing.

How to repeat:
n/a

Suggested fix:
change old_col_name new_col_name col_definition
[19 Sep 2007 13:21] Paul DuBois
The page indicates what column_definition means:

"column_definition clauses use the same syntax for ADD and CHANGE as for CREATE TABLE. Note that this syntax includes the column name, not just its data type."