I actually haven't seen that before :-( So, "CREATE TABLE AS" will basically duplicate the table that I have (if I say for example, "CREATE TABLE AS myNewTable AS SELECT * FROM myOldTable")? Sounds good if that's true :-)
Thanks, Dennis -----Original Message----- From: Dan Kennedy [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 2:05 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Copying a table between databases 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
