Just execute as the following. 1、create table b like a; 2、alter table b add ....; 3、insert into b select a..... 4、alter table b rename to a;
On Wed, Apr 16, 2008 at 11:08 PM, Arun Kumar PG <[EMAIL PROTECTED]> wrote: > given that my table is in myisam, there are some hacky way of doing this > (referred to this online) like creating table without keys, insert data > from > .myd, copy of .frm, .myi files for same table created with keys, and then > doing a repair table on new table.. > > but i was wondering if there is an easy way to do it. > > > On Wed, Apr 16, 2008 at 5:30 PM, Arun Kumar PG <[EMAIL PROTECTED]> > wrote: > > > hi, > > > > is there any other best way add a new column to an existing table having > > 60+ million records. alter is taking more than 1.5 hours.. what are the > best > > practices around this. quick help will be appreciated. > > > > -- > > cheers, > > > > - a > > > > > -- > cheers, > > - a > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
