orary table and reload
the data into it, like all Alter Table statements do?
Mike
> -Original Message-
> From: mos [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 13, 2005 5:24 PM
> To: mysql@lists.mysql.com
> Subject: Will "Alter Table ... enable keys"
2005 5:24 PM
> To: mysql@lists.mysql.com
> Subject: Will "Alter Table ... enable keys" reload data to table?
>
> I am importing data into a large table, 100 million rows, and
> I want to use "Alter table disable keys" prior to executing a
> Load Data.
I am importing data into a large table, 100 million rows, and I want to use
"Alter table disable keys" prior to executing a Load Data...,. But after
loading the data, if I execute a "Alter Table ... enable keys" will MySQL
create a second table, load the data into the second table, and then
reb