[sqlite] "select into" ?

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? Thanks, jim -

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 an

RE: [sqlite] "select into" ?

"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: sqlite-users@sqlite.org Subject: Re: [sqlite] "select into&quo

Re: [sqlite] "select into" ?

Anderson, James H (IT) wrote: 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? How about CREATE TAB

RE: [sqlite] "select into" ?

Perfect! Thanks. -Original Message- From: Gerry Snyder [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 5:28 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] "select into" ? Anderson, James H (IT) wrote: > Sybase supports "select into" but sqllite d

Re: [sqlite] "select into" ?

Anderson, James H (IT) wrote: 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? Thanks, jim -

[sqlite] SELECT INTO ... not supported?

Hi all, Something as simple as SELECT * INTO tblcopy FROM tbl; (where tbl is an existing table) gets the following error: SQL error: near "INTO": syntax error [version: 3.4.2 on Windows XP] I note that this syntax is not mentioned on the supported SQL syntax web page for SELECT, but it

[sqlite] Select Into not working

-- View this message in context: http://old.nabble.com/Select-Into-not-working-tp31420529p31420529.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mail

[sqlite] Select Into not working

I am attempting to copy records from one table to another using the syntax : Select field1, field2 into {empty table just created} from {existing table with a bunch of records} I get an error "Error near "Into" The destination table has only field1 and field2 which are also in the source table. T

[sqlite] Select Into not working

I am attempting to copy records from one table to another. The following statement is what i see everywhere when I google how to do this, yet it does not work. I am using the following: Select field1, field2 into {newly created table} from {existing table with lotsa records} I get an error Error n

Re: [sqlite] SELECT INTO ... not supported?

On 8/18/07, John Machin <[EMAIL PROTECTED]> wrote: > Something as simple as > SELECT * INTO tblcopy FROM tbl; > (where tbl is an existing table) gets the following error: > SQL error: near "INTO": syntax error > [version: 3.4.2 on Windows XP] > > I note that this syntax is not mentioned o

Re: [sqlite] Select Into not working

On 18 Apr 2011, at 4:40am, mhnSqlite wrote: > > [nothing] > -- You cannot post attachments to this list. You must type your message as text. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinf

Re: [sqlite] Select Into not working

On 18 Apr 2011, at 4:45am, mhnSqlite wrote: > I am attempting to copy records from one table to another using the syntax : > Select field1, field2 into {empty table just created} from {existing table > with a bunch of records} INSERT INTO newTable SELECT this,that FROM oldTable

Re: [sqlite] Select Into not working

mhnSqlite wrote: > I am attempting to copy records from one table to another. The following > statement is what i see everywhere when I google how to do this, yet it does > not work. > I am using the following: > Select field1, field2 into {newly created table} from {existing table with > lotsa re

[sqlite] Select into outfile C API

Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? I see the sqlite3 binary has an interactive .output parameter. Anything similar in the C API? TIA Pat... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8

[sqlite] Select into outfile C API

Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? I see the sqlite3 binary has an interactive .output parameter. Anything similar in the C API? TIA Pat... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8

[sqlite] SELECT INTO TEMP TABLE takes long

Hi, maybe, hopefully, I missed something, its still about this database: http://files.qvgps.com/0-tom-public/Geonames_World_2017.zip Copying just the ids from 12mio records ordered in a temp-table takes 60 seconds. There is a COLLATE NOCASE index on label. Is this normal or can this also be

Re: [sqlite] Select into outfile C API

On 4 Jun 2012, at 8:48pm, Patrick wrote: > Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? > I see the sqlite3 binary has an interactive .output parameter. Anything > similar in the C API? Nope. Sorry. You have to write your own C code to output to a file. The '.o

Re: [sqlite] Select into outfile C API

On 6/4/2012 3:48 PM, Patrick wrote: Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? No. But in your C program, you can always write code that reads results from SQLite, then writes them to a file in the format of your choice. I see the sqlite3 binary has an interact

Re: [sqlite] SELECT INTO TEMP TABLE takes long

On 31 May 2017, at 8:31pm, Thomas Flemming wrote: > Copying just the ids from 12mio records ordered in a temp-table takes 60 > seconds. There is a COLLATE NOCASE index on label. > > Is this normal or can this also be done faster? > > DROP TABLE IF EXISTS RowCursor; > CREATE TEMP TABLE RowCurs

Re: [sqlite] SELECT INTO TEMP TABLE takes long

On 2017/05/31 9:31 PM, Thomas Flemming wrote: Hi, maybe, hopefully, I missed something, its still about this database: http://files.qvgps.com/0-tom-public/Geonames_World_2017.zip Copying just the ids from 12mio records ordered in a temp-table takes 60 seconds. There is a COLLATE NOCASE index

Re: [sqlite] SELECT INTO TEMP TABLE takes long

Thanks guys for all the information. Now I know, how to proceed. Tom :) Am 31.05.2017 um 22:02 schrieb R Smith: On 2017/05/31 9:31 PM, Thomas Flemming wrote: Hi, maybe, hopefully, I missed something, its still about this database: http://files.qvgps.com/0-tom-public/Geonames_World_2017.zip

Re: [sqlite] SELECT INTO TEMP TABLE takes long

usesStmtJournal=0 11Goto 0 1 000 -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Thomas Flemming Sent: Wednesday, May 31, 2017 5:59 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [