List:General Discussion« Previous MessageNext Message »
From:Benjamin Pflugmann Date:July 26 2002 7:32pm
Subject:Re: Re[2]: TRUNCATE TABLE
View as plain text  
Hi.

First, when you start an independend question, please start a new
thread, but at least change the subject accordingly.

On Fri 2002-07-26 at 11:07:17 +0300, sitnikov@stripped wrote:
[...]
> If table recreated from table.frm why it not recreate indexes file?

Because this is the documented behaviour:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html ;-)

More seriously, it is explained in the cited section: "[...] CREATE
TABLE ... SELECT will not automatically create any indexes for
you. This is done intentionally to make the command as flexible as
possible. If you want to have indexes in the created table, you should
specify these before the SELECT statement"

Greetings,

	Benjamin.

-- 
benjamin-mysql@stripped
Thread
TRUNCATE TABLEAndrew Sitnikov25 Jul
  • Re: TRUNCATE TABLEDicky Wahyu Purnomo26 Jul
  • Re: TRUNCATE TABLEBenjamin Pflugmann26 Jul
    • Re[2]: TRUNCATE TABLEAndrew Sitnikov26 Jul
      • Re: Re[2]: TRUNCATE TABLEBenjamin Pflugmann26 Jul
    • Re[2]: TRUNCATE TABLEAndrew Sitnikov26 Jul
      • Re: Re[2]: TRUNCATE TABLEBenjamin Pflugmann26 Jul
        • Re[4]: TRUNCATE TABLEAndrew Sitnikov28 Jul
          • Re: Re[4]: TRUNCATE TABLEBenjamin Pflugmann29 Jul