List:General Discussion« Previous MessageNext Message »
From:Terry Burton Date:March 28 2006 1:59pm
Subject:CREATE TABLE x AS with ENGINE = ARCHIVE
View as plain text  
Hi,

I'm using MySQL 4.11. Is it possible to use the CREATE TABLE x AS
syntax alongside the ENGINE = x pragma, since this would make
archiving of tables very simple.

I require something along the lines of this:

CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE

If this cannot be done then I can always get equivalent functionality
by performing CREATE TABLE x (...) ENGINE=x followed by INSERT INTO x
SELECT * FROM x, however this is not so neat since it require
knowledge of the source table structure which makes it less ideal for
automation.


Many thanks,

Tez
Thread
CREATE TABLE x AS with ENGINE = ARCHIVETerry Burton28 Mar
  • Re: CREATE TABLE x AS with ENGINE = ARCHIVEPure Web Solution28 Mar
    • Re: CREATE TABLE x AS with ENGINE = ARCHIVETerry Burton28 Mar
  • Re: CREATE TABLE x AS with ENGINE = ARCHIVEPeter Brawley28 Mar
    • Re: CREATE TABLE x AS with ENGINE = ARCHIVETerry Burton28 Mar