Re: how do I export tables from one database and import into another datbase

["Jeremy D. Zawodny" <jzawodn@xxxxxxxxxxxxx>]

On Tue, Jan 02, 2001 at 01:29:55AM -0000, Mark Dundon wrote:

> I have two database's created.  I want to copy a few tables from one
> database to another database (including data).
> 
> How do I do that?

CREATE TABLE new_table SELECT * FROM old_table;

The relevant manual section is:

http://www.mysql.com/documentation/mysql/commented/manual.php?section=CREATE_TABLE

Jeremy
-- 
Jeremy D. Zawodny, <jzawodn@xxxxxxxxxxxxx>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878    Fax: (408) 530-5454
Cell: (408) 439-9951

-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60345@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php