AIL 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
>
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
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
--
