MySQL Forums :: Newbie :: Correcting spelling errors in an ENUM definition


Advanced Search

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?

Regards,
Meir

Options: ReplyQuote


Subject Written By Posted
Correcting spelling errors in an ENUM definition M. G. 10/19/2011 02:43AM
Re: Correcting spelling errors in an ENUM definition Peter Brawley 10/19/2011 08:05AM


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.