Ed, You could use the insert .. select syntax.
See: http://www.mysql.com/doc/en/INSERT_SELECT.html Cheers, Andrew -----Original Message----- From: [EMAIL PROTECTED] [mailto:ed@;home.homes2see.com] Sent: Thursday, 14 November 2002 18:50 To: [EMAIL PROTECTED] Subject: Copying one table to another Say I have 2 tables with the exact same formatting (fields, values, etc.) Is there an easy way to dump the contents of one table to the other in SQL rather than outputting the one to a .txt or .sql and inputing it into the other table? Thanks, Ed --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
