MySQL Forums
Forum List  »  Newbie

Correcting spelling errors in an ENUM definition
Posted by: M. G.
Date: October 19, 2011 02:43AM

Dear experts,

Say I defined a column as having an ENUM data type, but unfortunately made a spelling mistake in one of the values, such as:
Continent ENUM ('Euroqe', ...) ...

Unfortunately, the tables with that column definition (yes, plural, cut and paste...) where populated with lots of data, well before the spelling mistake was pointed out to me. (As always, one's mistakes are invisible to him/her but sticking out like a sore thumb to everybody else.)

All I want is to correct the spelling of the value, WITHOUT TOUCHING THE TABLES' DATA. Trying 'ALTER TABLE ...' seem to ADD a new value option and DROP the mistaken one with horrendous data losses.

Is there another way to do this? Is there a *.frm "editor" to just change the definition?


Options: ReplyQuote

Written By
Correcting spelling errors in an ENUM definition
October 19, 2011 02:43AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.