Doug-4 wrote:
Wouldn't INSERT OR REPLACE do that for you? (which by the way, has to be
one of the coolest features in SQLite of all!)
http://www.sqlite.org/lang_insert.html
insert or replace deletes all rows that weren't specified in the query, i
don't know maybe in combination with
Are you wanting something like this:
INSERT INTO 'mytable' (key, 'visitorcount', 'visitdate')
VALUES (123456789, 1, NOW())
ON DUPLICATE KEY UPDATE 'visitorcount' = 'visitorcount' + 1
the key statement being: ON DUPLICATE KEY UPDATE
not tested but it seems like that is what you are looking for.
´¯¯¯
INSERT INTO 'mytable' (key, 'visitorcount', 'visitdate')
VALUES (123456789, 1, NOW())
ON DUPLICATE KEY UPDATE 'visitorcount' = 'visitorcount' + 1
the key statement being: ON DUPLICATE KEY UPDATE
not tested but it seems like that is what you are looking for. Its
sometimes refered to
Geez. I am sorry. You are correct. This is MySQL. Sorry about
that and to the OP. (banging forehead with open faced palm of my
hand!!!)
Tony
On Sun, Sep 13, 2009 at 6:56 PM, Jean-Christophe Deschamps
j...@q-e-d.org wrote:
´¯¯¯
INSERT INTO 'mytable' (key, 'visitorcount', 'visitdate')
I see this:
CREATE TABLE table1( id INTEGER PRIMARY KEY ON CONFLICT REPLACE, field1 TEXT
);
but I think that the table has to already have been created this way.
I found that in the docs: http://sqlite.org/lang_conflict.html
Would that help the OP?
On Sun, Sep 13, 2009 at 6:56 PM,
Hi all, I was wondering if someone here could help me with understanding
/ solving an sqlite problem I'm having. Any help would be appreciated.
=SCHEMA=
CREATE TABLE pop_words_wpk (
word_id INTEGER PRIMARY KEY,
occurrences INTEGER
);
CREATE INDEX pop_words_wpk_oidx ON