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
Ok, thanks
I'll look around and see what fits my needs
Elie
On 28 November 2011 19:24, Black, Michael (IS) michael.bla...@ngc.comwrote:
There's a bunch of wrappers listed...you'll need to experiment unless
somebody knows what works on your device.
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
___
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 INTO foo
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
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 out
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 stat3
-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)
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
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 well
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
On Mon, Nov 28, 2011 at 9:21 PM, Adam Kennedy
adamkennedybac...@gmail.comwrote:
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
new
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
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
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.
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 of,
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:
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
.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
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:
sqlite
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
On Tue, Nov 29, 2011 at 2:56 PM, Black, Michael (IS)
michael.bla...@ngc.com 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
Thank you that works :)
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
--
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.
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
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 follow them
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
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.
/Roger
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 dfgri...@gmail.com wrote:
Sreekumar,
Regarding:
Is it possible to insert multiple rows using a single
30 matches
Mail list logo