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
RE: Copying one table to another
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
Re: Copying one table to another
Hi, You can use : INSERT INTO SELECT * FROM YOUR_TABLE Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 8:49 PM 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