On Mon, Sep 14, 2009 at 01:25:29AM -0700, yogibabu scratched on the wall:
>
>
>
> Jean-Christophe Deschamps wrote:
> >
> > Do you have a short example where "INSERT OR REPLACE INTO ..." can be
> > shown to actually _delete_ rows?
> > Which query are you refering to?
>
> sorry, i meant "column
At 10:25 14/09/2009, you wrote:
´¯¯¯
>sorry, i meant "columns" not rows, whet i do insert command, specifying
>existing id and only some of the columns then the rest of the columns are
>deleted
>on the other hand, UPDATE command won't allow me to insert a new row
Then you can still do something a
Jean-Christophe Deschamps wrote:
>
> Do you have a short example where "INSERT OR REPLACE INTO ..." can be
> shown to actually _delete_ rows?
> Which query are you refering to?
sorry, i meant "columns" not rows, whet i do insert command, specifying
existing id and only some of the columns the
At 01:29 14/09/2009, you wrote:
´¯¯¯
>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.
`---
Yes from what he said, I also believe this is the right and simplest way.
I tried twice to post it but it seems it didn't find its way to the
list. Sorry if ever it gets dupped.
Hi,
>insert or replace deletes all rows that weren't specified in the query
Do you have a short example where "INSERT OR REPLACE INTO ..." can be
shown to actually _delete_ rows?
Which que
UIT DEVELOPMENT wrote:
>
> 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
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, Jean-Christ
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
wrote:
>
>
> ´¯¯¯
>>INSERT INTO 'mytable' (key, 'visitorcount', 'visitdate')
>>VALUES (12
´¯¯¯
>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 t
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.
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
sqlite.org] On Behalf Of yogibabu
> Sent: Saturday, September 12, 2009 11:51 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] one liner for insert or update ?
>
>
> my dream is to be able do it like that:
> $pdo = new PDO('sqlite:database.DB3');
> $pdo-&
my dream is to be able do it like that:
query("INSERT UPDATE table SET value1='somedata', value2=somedata,
id=$getid ")
?>
when $getid contains data (a number of course) then an update is performed,
otherwise if it is null then database engine ignores `id` valule without any
notification and INSE
13 matches
Mail list logo
