Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#1094 renaming a column of a MyISAM table

fixed
Marc Delisle
None
5
2013-06-11
2008-06-07
Toralf Förster
No

should automatically alter the previously created index onto that column.

Discussion

  • Marc Delisle
    Marc Delisle
    2008-06-26

    Logged In: YES
    user_id=210714
    Originator: NO

    As tested on MySQL 5.0.51 + phpMyAdmin 2.11.6, when you renamed a column, a previously created index or primary key now contains the new column name. Please provide a test case if you can.

     
  • Marc Delisle
    Marc Delisle
    2008-06-26

    • assigned_to: nobody --> lem9
    • status: open --> pending
     
    • status: pending --> open
     
  • Logged In: YES
    user_id=1358563
    Originator: YES

    thx

    test case:
    1) log into test db
    2) create table "tab01" as :

    Field Type Null Default Comments
    hostname varchar(12) No
    port varchar(10) No

    3) create index for column "hostname"
    4) rename "hostname" to "hostname2"

    works now as expected
    :-)

     
  • Marc Delisle
    Marc Delisle
    2008-06-27

    • status: open --> closed
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed --> fixed