irectory.
#2What happend with old table after alter?
It is dropped if the "alter table" is successful and the temp table is
renamed to the old table name.
Mike
From: mos <[EMAIL PROTECTED]>
To: "Mike Mapsnac" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: R
Thanks for good explnation.
Some more questions:
#1Does 'update' also create temporary table?
#2What happend with old table after alter?
From: mos <[EMAIL PROTECTED]>
To: "Mike Mapsnac" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Kill "alter tabl
At 05:34 PM 1/21/2004, you wrote:
I run alter today on table with 380,000 records. 'Alter' was adding
column to the table. It took 10 minutes and server load went up to
15.
"alter table info add column interactive_email enum('on','off') NOT NULL
default 'on';"
Here comes my questions:
#1 If I ki
I run alter today on table with 380,000 records. 'Alter' was adding
column to the table. It took 10 minutes and server load went up to
15.
"alter table info add column interactive_email enum('on','off') NOT NULL
default 'on';"
Here comes my questions:
#1 If I kill the process after it was runnin
On Fri, Mar 02, 2001 at 09:27:50AM +1300, Quentin Bennett wrote:
> Hi,
>
> Would
>
> ALTER TABLE mytable ADD INDEX (somecol, othercol), ADD INDEX (othercol);
>
> do this in one sweep of the table, creating one temporary copy, or go
> through the table twice, one for each index?
>
One run for
Hi,
Would
ALTER TABLE mytable ADD INDEX (somecol, othercol), ADD INDEX (othercol);
do this in one sweep of the table, creating one temporary copy, or go
through the table twice, one for each index?
Quentin Bennett
Transport Systems Division
Infinity Solutions
web http:\\www.infinity.co.nz
ma
