re: create table ... select ... w/ index

2002-12-12 Thread Egor Egorov
On Thursday 12 December 2002 05:52, Amittai Aviram wrote: > When you copy a table using CREATE TABLE ... SELECT ..., the indexes do not > get copied automatically. Is there a convenient way to transfer all > indexes, other than looking them up with DESCRIBE or SHOW INDEX and then > using either A

create table ... select ... w/ index

2002-12-11 Thread Amittai Aviram
When you copy a table using CREATE TABLE ... SELECT ..., the indexes do not get copied automatically. Is there a convenient way to transfer all indexes, other than looking them up with DESCRIBE or SHOW INDEX and then using either ALTER TABLE ADD INDEX, etc., or CREATE INDEX? Thanks! Amittai Avir