edit enum values in mysql
by Ramya[ Edit ] 2010-11-22 12:55:42
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;
