[sqlite] Inserting Multiple Rows in a single statement

Hello, Is it possible to insert multiple rows using a single statement ? Kind Regards, Sreekumar ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite on CVM

Ok, thanks I'll look around and see what fits my needs Elie On 28 November 2011 19:24, Black, Michael (IS) wrote: > There's a bunch of wrappers listed...you'll need to experiment unless > somebody knows what works on your device. > >

Re: [sqlite] Inserting Multiple Rows in a single statement

Sreekumar TP wrote: Is it possible to insert multiple rows using a single statement ? Yes. INSERT INTO foo (x, y) VALUES (1,2), (3,4), (5,6),...; INSERT INTO foo (x,y) SELECT x, y FROM bar; That's at least 2 ways. -- Darren Duncan ___

Re: [sqlite] Inserting Multiple Rows in a single statement

On Nov 29, 2011, at 10:47 AM, Darren Duncan wrote: >> Is it possible to insert multiple rows using a single statement ? > > Yes. > > INSERT INTO foo (x, y) > VALUES (1,2), (3,4), (5,6),...; I don't think this syntax is supported by SQLite: http://www.sqlite.org/lang_insert.html > > INSERT

[sqlite] Are SQLITE_ENABLE_STAT3 tables created when upgrading?

Consider an SQLite database created with the SQLITE_ENABLE_STAT2 flag set. After updating my software, the new SQLite version seems to use another flag; SQLITE_ENABLE_STAT3. Will these stat3 optimizations be available when opening and old database created with stat2? Or is it perhaps

Re: [sqlite] Newbie question on Data Source

I'll note a few things here... #1 If you want to learn about "database design" or "how to code in language X" get a book on those and not on a particular product (you may want the product book too if you need it but those tend to be less helpful). #2 Your first language will be hard to get

Re: [sqlite] Are SQLITE_ENABLE_STAT3 tables created when upgrading?

On Tue, Nov 29, 2011 at 7:00 AM, Kristoffer Danielsson < kristoffer.daniels...@live.se> wrote: > > > > > Consider an SQLite database created with the SQLITE_ENABLE_STAT2 flag set. > After updating my software, the new SQLite version seems to use another > flag; SQLITE_ENABLE_STAT3. Will these

Re: [sqlite] Newbie question on Data Source

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/29/2011 12:17 PM, Black, Michael (IS) wrote: > I'll note a few things here... [snip] Much good advice. Seconded! ABS - -- Alaric Snell-Pym http://www.snell-pym.org.uk/alaric/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux)

Re: [sqlite] Are SQLITE_ENABLE_STAT3 tables created when upgrading?

Thanks. The documentation states that this new stat3 is better than stat2. Do you have any benchmarks or similar that show the win? > From: d...@sqlite.org > Date: Tue, 29 Nov 2011 07:21:17 -0500 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Are SQLITE_ENABLE_STAT3 tables created when

Re: [sqlite] Are SQLITE_ENABLE_STAT3 tables created when upgrading?

On Tue, Nov 29, 2011 at 7:50 AM, Kristoffer Danielsson < kristoffer.daniels...@live.se> wrote: > > Thanks. The documentation states that this new stat3 is better than stat2. > Do you have any benchmarks or similar that show the win? > No benchmarks. But there are corner cases that stat3 handles

[sqlite] DBD::SQLite 1.35, and speeding up databases created before 3.7.8

Firstly, I have just released a new Perl DBD::SQLite module, which fixes a few perl-side bugs and moves us from 3.7.7 to 3.7.9. Secondly, for a collection of arbitrary SQLite database files with unknown schemas that were created before 3.7.8, is it possible to do bulk-processing of the databases

Re: [sqlite] DBD::SQLite 1.35, and speeding up databases created before 3.7.8

On Mon, Nov 28, 2011 at 9:21 PM, Adam Kennedy wrote: > > Secondly, for a collection of arbitrary SQLite database files with > unknown schemas that were created before 3.7.8, is it possible to do > bulk-processing of the databases to gain the speed improvements of the

Re: [sqlite] Newbie question on Data Source

Michael, #1 Thanks for the comments. I have the book, The Definitive Guide to SQLite from Apress by Michael Owens, but it is the 2006 first edition. Do you, or anyone, know if the new or 2nd edition is worth buying or does it just cover 1 new item? I am not afraid to buy books. You should

Re: [sqlite] EXT :Re: Newbie question on Data Source

You don't need to pay moneythe concepts are available all over the place For example: http://search.4shared.com/postDownload/AHGWfQwG/Database_Design_For_Mere_Morta.html If you ran a BBS on a C64 you may have been running my software. I sold a BBS system back in the early 80's (didn't

Re: [sqlite] EXT :Re: Newbie question on Data Source

Michael, Just looked at my bookshelf. I already own the 2nd Edition of that book. Better get it off the shelf and look at it again and see if it reads better. :) I ran Vision BBS by Kerry Messana and have version 2.0 here in my cabinet. Here is the link to version 1.0 info.

Re: [sqlite] Inserting Multiple Rows in a single statement

Sreekumar, Regarding: > > Is it possible to insert multiple rows using a single statement ? > You might want to let us know your reasons for requesting this. If it's speed of insertion you're after, then be sure to put many INSERT's into each transaction. That is, be sure to surround a batch

Re: [sqlite] EXT :Re: Newbie question on Data Source

Michael, I found the info on your BBS there too: http://www.zimmers.net/bbs/aabbs.html Dave On 11/29/2011 8:57 AM, Black, Michael (IS) wrote: You don't need to pay moneythe concepts are available all over the place For example:

[sqlite] Runfile script over existing Database

Hi all, i have a question. I have a script with edit a database file (insert and alter some tables). Now I want to run this script agains an existing database file, with the commandline shell. How can I do this in a batch file (windows) I don't understand the ".read" command. Regards Steffen

Re: [sqlite] Runfile script over existing Database

.read would be one way...but this is more direct If you have a set of SQL statements in "myfile.sql" that you want to run on "test.db" you can do this: type myfile.sql | sqlite3 test.db myfile.sql example between the lines: create table t(a int); insert into t

Re: [sqlite] Runfile script over existing Database

Thanks for your fast answere and hi michael, > > type myfile.sql | sqlite3 test.db > Pleae don't laught, but I don't get it to run... :( Let me tell what im doing: 1. start "cmd.exe" 2. go to directory with sqlite3.exe 3. > sqlite3.exe (Return) 4. test.sql | "test.db3" The result is only:

Re: [sqlite] Runfile script over existing Database

In your words: 1. start "cmd.exe" 2. go to directory with sqlite3.exe 3. type test.sql | sqlite3 test.db3 (Return) Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems

Re: [sqlite] Runfile script over existing Database

On Tue, Nov 29, 2011 at 2:56 PM, Black, Michael (IS) wrote: > In your words: > > 1. start "cmd.exe" > > 2. go to directory with sqlite3.exe > > 3. type test.sql | sqlite3 test.db3 (Return) Don't get confused: you should type the word "type" here. ;) Pavel

Re: [sqlite] Runfile script over existing Database

Thank you that works :) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Runfile script over existing Database

Now i have the problem that the sqlite3.exe has a problem with "ä, ö, ü" in Database filename. :( It makes a new db called " D�sseldorf " for example and fails then :( Steffen Mangold

[sqlite] Looping select

This one is weird. And I don't know exactly what I have the ability to provide you for information. Below is the C# code I use to execute a query. And below that is what is ultimately translated and executed. The c# application appears to get hung up and loops. It burns cpu, but never stops.

Re: [sqlite] Managed only / Mono and Linux support

On 29.11.2011 04:49 CE(S)T, Joe Mistachkin wrote: > Adding yet another > pre-compiled set of binary packages for Mono would just serve to make things > even more confusing. Maybe some kind of grid-layout or wizard-style overview would be useful to find the right download. I regularly get confused

Re: [sqlite] ADO provider for net 2.0/3.5

Marc Hornung wrote: > > Are there procedures of some sort that need to followed in the > process of performing this testing that you would like me to follow? And > document against? > There aren't formal procedures yet. > > If you have any guidelines or instructions I would be happy to

Re: [sqlite] Managed only / Mono and Linux support

Yves Goergen wrote: > > So, where could I have found that information if not here? > Good point, I'll add that command line to the "Build Procedures" page on the web site. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Runfile script over existing Database

On 11/29/11 23:25, Steffen Mangold wrote: Now i have the problem that the sqlite3.exe has a problem with "ä, ö, ü" in Database filename. :( It makes a new db called " D�sseldorf " for example and fails then :( Steffen Mangold Try creating a bat-file with the cmd-commands and run it.

Re: [sqlite] Inserting Multiple Rows in a single statement

Hi, I do have multiple insertions bounded by BEGIN-COMMIT . I am looking at possibilities of making the insertions faster. -Sreekumar On Tue, Nov 29, 2011 at 4:36 PM, Donald Griggs wrote: > Sreekumar, > > Regarding: > > > > Is it possible to insert multiple rows using a