"select into" creates the table; "insert into" requires that the table already exist.
-----Original Message----- From: Jeff Godfrey [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 5:12 PM To: [email protected] Subject: Re: [sqlite] "select into" ? > ----- Original Message ----- > From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> > > Sybase supports "select into" but sqllite does not seem to. Here's a > sybase example: > > select distinct CDId, CDEvent > into credDerivEvent > from credDerivOrig > > This query creates the table credDerivEvent. Is there anythin > comparable > in sqlite? I'm no expert, but how does that differ from "insert into ??? select ??? from ???", which is supported by sqlite? Jeff ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- -------------------------------------------------------- NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
