471,075 Members | 1,272 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

Changing ENUM Values

So I've got fairly big sized table (20,000 records) which has an ENUM
row. I need to change the name of one of the ENUM options. For
example, if the ENUM value was 'blue' before, it needs to be 'purple'
now. What's the best way to do this?

Thanks,
-Aaron
---------------
Aaron Blew
Jackson County School District #6 Network/Systems Analyst
aa********@district6.org
(541)494-6900

You can destroy your now by worrying about tomorrow.
-- Janis Joplin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1894

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Aaron Blew | last post: by
reply views Thread by Vaclav Haisman | last post: by
3 posts views Thread by Richard | last post: by
13 posts views Thread by Adam Blair | last post: by
18 posts views Thread by Visual Systems AB \(Martin Arvidsson\) | last post: by
10 posts views Thread by kar1107 | last post: by
34 posts views Thread by Steven Nagy | last post: by
6 posts views Thread by bsma1 | last post: by
9 posts views Thread by Jamey Bon | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.