Hi all. What's the quickest way to copy a table so that all column attributes such as auto_increment and primary key along with all indexes get copied over? I like using:
create table new_table select * from old_table But it doesn't copy any indexes or those special attributes I mentioned over to the new table. I know this can be done using mysqldump but I'm wondering if there's something quicker (less involved). Thanks. David --------------------------------------------------------------------- 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
