Hi Christophe,
On 12/9/08, Christophe Leske <[EMAIL PROTECTED]> wrote:
> the difference between a normal "where"-clause and the "Group by", and
> "having"
I used www.sqlcourse.com and sqlcourse2.com probably in the year 2000.
They had very good tutorials and also let your actually practice the
S
On ti., 2008-12-09 at 11:29 -0500, D. Richard Hipp wrote:
> On Dec 9, 2008, at 11:23 AM, Kent Dahl wrote:
> > After running valgrind on my program that is using sqlite (3.6.6.2,
> > statically linked on Linux, Ubuntu 8.10) for a while, carving away all
> > the problems caused by my own code, I was
On Sat, Nov 29, 2008 at 7:56 PM, Rael Bauer <[EMAIL PROTECTED]> wrote:
> Previously someone advised that I use the "*" char to achieve partial search
> results with fts. eg ver* will match version. This works ok, but only for
> end parts of a word.
>
> Is there anyway to get partial matches for beg
On Mon, Dec 8, 2008 at 8:26 AM, Jos van den Oever <[EMAIL PROTECTED]> wrote:
> Can one retrieve the number of times a certain term occurs in an fts table?
> This can be useful for autocompletion comboboxes.
Unfortunately, this information isn't tracked in an easy-to-expose
fashion. It would be ni
I tried without AS but still get same error : SQL error: no such column: f.type
Maybe sqlite 2.8.17 can't run that query
On Tue, Dec 9, 2008 at 1:50 PM, Jonas Sandman <[EMAIL PROTECTED]> wrote:
> Shouldn't it be
>
> select f.type, f.variety, f.price
> from
> fruits f
> where
> rowid in (select row
> Marcus Grimm wrote:
>> I skipped to use the busy handler and the busy timeout and do
>> the handling by my selve. typically like:
>
> Are you aware that your code is very similar to the default SQLite busy
> handler if you set a busy timeout? I'd argue that the one shipped with
> SQLite is bette
Marcus Grimm wrote:
> I skipped to use the busy handler and the busy timeout and do
> the handling by my selve. typically like:
Are you aware that your code is very similar to the default SQLite busy
handler if you set a busy timeout? I'd argue that the one shipped with
SQLite is better since it
Marco Bambini <[EMAIL PROTECTED]> wrote:
> I have several threads inside an application and each thread opens a
> connection to the same database.
> The application has been compiled with SQLITE_THREADSAFE = 1.
> One of the threads (just one) open another database connection to the
> same database
Has anyone here used RoundCube with SQLite? Apparently it still requries
SQLite 2.x and I can't find any modern Linux box that still ships 2.x. I
just need to run these commands:
http://www.perturb.org/tmp/sqlite.initial.sql
And get the 2.x binary DB from it. Is there a way to make SQLite 3 outpu
Dump the database as SQL, then execute the SQL with PostgreSQL.
Manisha De Silva wrote:
> Now that I have a textfile which has a sqlite database can this be added to a
> postgresql database? If so how?
> This message (and any associated files) is intended only for the use of the
> individual to w
Open up a command prompt window. Then key
sqlite3
That will ring up a command line accessto your Sqlite database.
If you want a GUI interface there is a Firefox plugin which interfaces
to Sqlite. Try that or one of the very many Sqlite GUI interfaces like
Sqlitespy.
Manisha De Silva wrote
Hi,
i remember the posts you mention, and I know these error reports from
valgrind. I get them outside of sqlite also, and have learned to ignore
them.
Martin
Kent Dahl schrieb:
> Hi.
>
> After running valgrind on my program that is using sqlite (3.6.6.2,
> statically linked on Linux, Ubuntu 8
On Dec 9, 2008, at 11:23 AM, Kent Dahl wrote:
> Hi.
>
> After running valgrind on my program that is using sqlite (3.6.6.2,
> statically linked on Linux, Ubuntu 8.10) for a while, carving away all
> the problems caused by my own code, I was left with the "Syscall param
> write(buf) points to unin
Hi.
After running valgrind on my program that is using sqlite (3.6.6.2,
statically linked on Linux, Ubuntu 8.10) for a while, carving away all
the problems caused by my own code, I was left with the "Syscall param
write(buf) points to uninitialised byte(s)" error reported within the
call from writ
Now that I have a textfile which has a sqlite database can this be added to a
postgresql database? If so how?
This message (and any associated files) is intended only for the use of the
individual to which it is addressed and may contain information that is
confidential, subject to copyright prot
On 12/9/08, Manisha De Silva <[EMAIL PROTECTED]> wrote:
> I tried this line of code to do a data dump but it doesn't seem to work
>
>
> sqlite> .dump sqlite3 c:\spool\jsm.db gzip -c > jsm.dump.gz
> BEGIN TRANSACTION;
> COMMIT;
> sqlite>
>
>
You seriously need to read the docs and the help firs
...
This is what I was trying to do :
I double clicked on sqlite3.exe
Then it opens a sqlite prompt
Now I need to a do a data dump of a file which resides in
c:\spool\jsm.db where jsm.db is the sqlite database.
How can this be done?
Ah, I see.
Sqlite3.exe is re
I tried this line of code to do a data dump but it doesn't seem to work
sqlite> .dump sqlite3 c:\spool\jsm.db gzip -c > jsm.dump.gz
BEGIN TRANSACTION;
COMMIT;
sqlite>
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Manisha De Silva
Sent: 09 December 20
Hi,
This is what I was trying to do :
I double clicked on sqlite3.exe
Then it opens a sqlite prompt
Now I need to a do a data dump of a file which resides in c:\spool\jsm.db
where jsm.db is the sqlite database.
How can this be done?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[
I'm not certain I understand your question, but here goes:
Sqlite3.exe is a command-line interface, so you don't really "browse" at
all.
However, you can specify the path and name of a database on the command
line when you invoke sqlite3, e.g. (In windows):
Sqlite3 "c:\NiceDirectory_Without_spac
On 12/9/08, Manisha De Silva <[EMAIL PROTECTED]> wrote:
> I downloaded sqlite3.exe
>
> I typed in .databases and it doesn't show any database. Actually I have
> sqlite db in C:\Program Files\Jabber Inc\Jabber XCP\var\spool and I want this
> to dump the data to a text file.
>
> I typed in sqlite
I downloaded sqlite3.exe
I typed in .databases and it doesn't show any database. Actually I have
sqlite db in C:\Program Files\Jabber Inc\Jabber XCP\var\spool and I want this
to dump the data to a text file.
I typed in sqlite> .databases
How can I browse to the specific folder name which contai
> Think of HAVING as being analogous to WHERE. While WHERE applies to
> the TABLE, HAVING applies to the results of GROUP. Here is a contrive
yes, thank you.
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Ger
[EMAIL PROTECTED] wrote:
> http://www.w3schools.com/sql/default.asp
>
Thanks! That is great!
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
On 12/9/08, Christophe Leske <[EMAIL PROTECTED]> wrote:
> Hi,
>
> can someone point me to some docs where the difference between a normal
> "where"-clause and the "Group by", and "having" statements are being
> explained?
>
Think of HAVING as being analogous to WHERE. While WHERE applies to
the
http://www.w3schools.com/sql/default.asp
RBS
> Hi,
>
> can someone point me to some docs where the difference between a normal
> "where"-clause and the "Group by", and "having" statements are being
> explained?
>
> I don´t quite understand what these are actually good for.
>
> Thanks,
>
> --
> Ch
Hi,
can someone point me to some docs where the difference between a normal
"where"-clause and the "Group by", and "having" statements are being
explained?
I don´t quite understand what these are actually good for.
Thanks,
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://ww
On Tue, Dec 9, 2008 at 8:59 AM, Manisha De Silva
<[EMAIL PROTECTED]> wrote:
> I want to do a data dump to a text file, how is it possible to do this in
> SQLite?
Look at the appropriately named .dump command in the sqlite3 shell.
By the way, do you realize that you have a 20 word message followed
I want to do a data dump to a text file, how is it possible to do this in
SQLite?
This message (and any associated files) is intended only for the use of the
individual to which it is addressed and may contain information that is
confidential, subject to copyright protection. If you are not the i
Hello Rachmat,
by creating one and using a fitting where- or order-by - clause.
See http://www.sqlite.org/lang_createindex.html
perhaps you would like to ask you question with a litte bit morte detail?
Martin
Rachmat Febfauza schrieb:
> how to make sqlite use index?
>
>
>
>
> __
how to make sqlite use index?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi,
I also spend some time with a similar application and sqlite
is doing quite well so far, however you will get BUSY states
and LOCK states under "normal" condition and you will need
to handle them.
I skipped to use the busy handler and the busy timeout and do
the handling by my selve. typically
I have several threads inside an application and each thread opens a
connection to the same database.
The application has been compiled with SQLITE_THREADSAFE = 1.
One of the threads (just one) open another database connection to the
same database used by ALL threads for all the writing operati
Hello,
The API function sqlite_changes reports the number of rows changed in the last
update/insert/delete. I'd like to use this in a generic SQL-tracing tool and
find it a bit inconvenient as the value can only be used if the statement was
an update/insert/delete. Is there a reason that the va
34 matches
Mail list logo
