subject:"Re\: \[sqlite\] Copy Table Values"

Re: [sqlite] Copy Table Values

2006-12-12 Thread Rich Shepard


On Tue, 12 Dec 2006, [EMAIL PROTECTED] wrote:


INSERT INTO ... SELECT ...


  A-ha! Thank you very much.

Rich

--
Richard B. Shepard, Ph.D.   |The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)|Accelerator
 Voice: 503-667-4517  Fax: 503-667-8863

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Copy Table Values

2006-12-12 Thread drh

Rich Shepard <[EMAIL PROTECTED]> wrote:
> I want to copy field values for two columns in one table into the
> equivalent columns in another table. I don't find a 'select ... into' option
> in the web page syntax for the command. How should I go about doing this
> data copy?
> 

INSERT INTO ... SELECT ...
--
D. Richard Hipp  <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-