If i have a table with about 800M records. and one of the fields is a enum("a", "b", "c") and i want to change it to enum("a","b","x") will it fall into some optimization and be instant?
and what if previously i've never used the "c" value? isn't there any optimization for that? ...leaving "blank" labels on a enum? or another command to "add" new labels to a enum? thanks, Gabriel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]