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
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
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
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
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
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