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 ALTER TABLE ADD INDEX, etc., or CREATE INDEX?
You can get output of SHOW CREATE TABLE, create table with indexes, then INSERT .. SELECT or do as you've described :) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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