edit enum values in mysql

edit enum values in mysql - Mysql

Tagged in : Mysql

edit enum values in mysql:

To edit enum values in mysql use "alter" command,

for eg,
if you have just three languages in enum type and want to update it with 3 more then,

ALTER TABLE `tablename` CHANGE `fieldname` `fieldname` ENUM('English', 'Spanish', 'French', 'Chinese', 'German', 'Japanese')

then list the structure of the table using desc command,

desc tablename;

By Ramya, On - 2010-11-22

PreviousNext

   
				Login to add Comments .

CSK the leads.. Always... "Enna irunthalum Tamilan Da.."

Yes.. where is the funny moments? i dint see any funny moments..

Its not guesses sir.. its real

Girls always rocks.. But, ashok just miss thambi... Anyways all the best for all three..

Nice Video..

it's really awesome video....

Green leaf indicates fresh ideas, red bud for intensity, passion or energy and the direction in which the symbol is placed indicates progress.

Extraordinary video

Very gud one

nice

Play Games Online

Amazing World Facts

Cool Email Forwards

Watch Videos Online

plesk api sushmitha 12th php mail getting values new google

vijay next vijay next google doodles who will microsoft's new