Re: best way to add a new column to a table with 60+ million records

2008-05-25 Thread Ananda Kumar
oing 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 t

Re: best way to add a new column to a table with 60+ million records

2008-05-25 Thread Moon's Father
r 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 > > practice

Re: best way to add a new column to a table with 60+ million records

2008-04-16 Thread Arun Kumar PG
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 thi

best way to add a new column to a table with 60+ million records

2008-04-16 Thread Arun Kumar PG
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

Re: add a new column

2001-09-08 Thread Michael Wittmann
wer. Can you answer it?? Thanks! Here is it: I have a db in > mysql (off course!) with a lot of data. Can I add a new column (a new > variable) to an existing table??? If yes, what's is the sql query?? Thanks! > > Thanking in Advance, > Nuno Lopes > > P.S.: When you reply to

add a new column

2001-09-08 Thread Nuno Lopes
Hi everybody, I have an answer. Can you answer it?? Thanks! Here is it: I have a db in mysql (off course!) with a lot of data. Can I add a new column (a new variable) to an existing table??? If yes, what's is the sql query?? Thanks! Thanking in Advance, Nuno Lopes P.S.: When you reply t