[sqlite] Copy Table Values

2006-12-12 Thread Rich Shepard 

  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?

Thanks,

Rich

--
Richard B. Shepard, Ph.D.   |The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)|Accelerator
http://www.appl-ecosys.com 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]
-

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
http://www.appl-ecosys.com Voice: 503-667-4517  Fax: 503-667-8863

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