Better would be
Insert into tablea(ida, value1a)
Select idb, value1b
from tableb
where idb not in(select ida from tablea);
Woody
from his pda
-Original Message-
From: Lothar Behrens <[EMAIL PROTECTED]>
Sent: Saturday, May 10, 2008 2:23 PM
To: sqlite-users@sqlite.org
"Lothar Behrens"
<[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> Executing this statemen twice creates two rows:
>
> replace into anwendungen (name) values ('lbDMF Manager')
Make "name" column unique, or create a unique index on it.
Igor Tandetnik
Hi,
I am searching for a sample that uses the case when expression.
I like to insert values into a table when these values are not in that
table before.
My tries to read, understand and try the documentation of expressions
failed.
Executing this statemen twice creates two rows:
replace into
On Sat, 2008-05-10 at 10:11 -0700, Jim Dodgen wrote:
> SQLite is rock solid.
>
> Also I don't think it wise to develop on a different DBMS that the one
> you are going to use in production.
Perhaps Sebastian Stephenson was referring to the "stand-in for an
enterprise database during demos or
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Some methods such as xRead return an error that is sometimes considered
a success such as SQLITE_IOERR_SHORT_READ. This significantly
complicates things in wrappers as sqlite errors map to exceptions, and
so sometimes they need to be cleared and
SQLite is rock solid.
Also I don't think it wise to develop on a different DBMS that the one
you are going to use in production.
sebastian stephenson wrote:
> I see that sqlite is great for development but for production would
> that be a bright idea?
> see ya
>
> sebey
>
>
>
Thanks Keith,
found them here: http://www.sqlite.org/sqlite-source-2_8_17.zip
On Sat, 10 May 2008 07:08:44 -0700
"Keith Goodman" <[EMAIL PROTECTED]> wrote:
> On Sat, May 10, 2008 at 4:38 AM, [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
> > where do I find the latest sqlite2 tarball ?
>
>
On Sat, May 10, 2008 at 4:38 AM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> where do I find the latest sqlite2 tarball ?
If you have a cvs client:
(from http://www.sqlite.org/download.html)
All SQLite source code is maintained in a CVS repository that is
available for read-only access by
On Sat, 10 May 2008, sebastian stephenson wrote:
> I see that sqlite is great for development but for production would that
> be a bright idea?
In addition to Roger's comment, take a look at the web site. The home page
shows that Adobe, Mozilla, and Symbian are sponsors.
Why would you
2008/5/10 sebastian stephenson <[EMAIL PROTECTED]>:
>
> I see that sqlite is great for development but for production would
> that be a bright idea?
> see ya
>
it you develop a single user embedded sw than sqlite is a good solution, if
you develop a db for a really BIG with many concurrent write
"Mahalakshmi.m"
<[EMAIL PROTECTED]> wrote
in message
news:[EMAIL PROTECTED]
> What about Japanese Kanji?
>
> Will sqlite sort all the Hiragana,Katakana,Kanji.
Not out of the box. You will have to implement a custom collation. Or,
you can build SQLite with ICU support, then it will use ICU
Hi All,
where do I find the latest sqlite2 tarball ?
Thanks for supporting,
Mike
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
sebastian stephenson wrote:
> I see that sqlite is great for development but for production would
> that be a bright idea?
http://sqlite.org/famous.html
There are many many other people using it production, such as the
majority of people on this
What about Japanese Kanji?
Will sqlite sort all the Hiragana,Katakana,Kanji.
I am having some records with starting Unicode as follows.
6B4C Kanji 歌手生活25周却記念 北島三石1
30A2 Katakana アンテナ
I am storing it using sqlite3_bind_text16().
But if I sort the above two the Unicode with
I see that sqlite is great for development but for production would
that be a bright idea?
see ya
sebey
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
15 matches
Mail list logo