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'
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
> (ref
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 eas
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
