Hello Andrew.
My apologies. I somehow completely mixed up my answer. This answer was
intended to a posting which asked why indexes are not copied on CREATE
... SELECT. Don't know how I managed to fit this answer onto your
posting without noticing. Day dreaming or something. :-(
Greetings,
Benjamin.
On Sat 2002-07-27 at 20:53:45 +0300, [EMAIL PROTECTED] wrote:
>
> BP> Hi.
>
> BP> First, when you start an independend question, please start a new
> BP> thread, but at least change the subject accordingly.
> This is not independent question. Manual say what TRUNCATE TABLE will
> recreate table from frm file, but when i use TRUNCATE TABLE, index file
> will not recreated, becouse it have old data and it size is biger than
> after CREATE TABLE ...
>
> >> If table recreated from table.frm why it not recreate indexes file?
> BP> Because this is the documented behaviour:
> BP> http://www.mysql.com/doc/C/R/CREATE_TABLE.html ;-)
> I spoke about TRUNCATE TABLE, not about CREATE ... SELECT ...
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
