There's always "CREATE TABLE ... AS ...", but not everybody is happy
with the column names and types it creates.
--- Dennis Volodomanov <[EMAIL PROTECTED]> wrote:
> Just wondering, is there any mechanism to help me achieve that
> functionality or should I go the DROP, CREATE, SELECT and INSERT path?
>
> Thanks,
>
> Dennis
>
> -----Original Message-----
> From: Dennis Volodomanov
> Sent: Wednesday, April 13, 2005 10:14 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Copying a table between databases
>
> Hello all,
>
> What is the best way to copy (not move) a table between an existing
> database and a blank, attached database using SQLite v3? The COPY
> command is gone, what else can I use?
>
> Thank you.
>
> Dennis
>
>
>
>
>
>
__________________________________
Do you Yahoo!?
Make Yahoo! your home page
http://www.yahoo.com/r/hs
