On 6/16/05, Gabriel B. <[EMAIL PROTECTED]> wrote:
> 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")
My understanding (such as it is) is that the best way to do this is to add a
second column with enum('a','b
n may just be faster than
the ALTER TABLE on the fully populated table.
-Original Message-
From: Gabriel B. [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 16, 2005 1:18 PM
To: mysql@lists.mysql.com
Subject: Re: alter only an enum label
hum... clever. i liked that solution.
but do have ex
;,'b','c','x')
> DEFAULT "a" NOT NULL
>
> then
>
> UPDATE tablename SET columname = 'x' WHERE columname = 'c'
>
> Then
>
> ALTER TABLE tablename CHANGE columnname columnname ENUM('a','b','x
27;c'
Then
ALTER TABLE tablename CHANGE columnname columnname ENUM('a','b','x')
DEFAULT "a" NOT NULL
-Original Message-
From: Gabriel B. [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 16, 2005 12:54 PM
To: LISTA mysql
Subject: alter only an en
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
