Re: Memory table questions

2005-02-21 Thread Gleb Paharenko
Hello. You may use 'CREATE TABLE ... SELECT' statement: create table t3 type=heap select * from t2; But be careful, as it doesn't create indexes automatically, unless you specify them manually in your statement. See: http://dev.mysql.com/doc/mysql/en/create-table.html You may put

Memory table questions

2005-02-20 Thread gunmuse
We are building two copies of our commonly used tables.  When we have to write something we write it Both tables:   TABLE A TABLE B MEMORY table   When we read to run our script we only read from he MEMORY TABLE.   My question is how do I tell TABLE B to clone TABLE A after a reboot automat