Also, The below method will not add it the default values for date's and also will create the indexes and if any column is set as auto increment, that also need to be take care.
So, is there a way to take care of the above, in the create table statement itself. regards anandkl On 5/26/08, Moon's Father <[EMAIL PROTECTED]> wrote: > > 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 >
