[sqlite] REPLACE statement

[Richard Boehme]

In my database, I am going to be inserting many rows at a time. There 
might be duplicate rows in the database which I would not know the 
primary key for. There are several databases on several computers 
merging into one database which the first ones only occasionally 
contact. The schema so far is this:

CREATE TABLE Playlist
(
  PlaylistID     integer PRIMARY KEY,
  ComputerID     integer,
  NetworkID      integer,
  PlaylistNum    integer,
  PlaylistItems  text,
  LastUpdated    text
);
It would need to replace any  playlist with the same PlaylistItems and 
NetworkID, for instance. In otherwords, my criterion for if it gets 
updated rather than inserted is if two or three keys match exactly. Is 
there a good way to do this with a lot of transactions? I'm not sure how 
flexible the REPLACE command or triggers would be for this. And as I 
mentioned, it might be on a couple thousnad rows at a time, so I would 
like to have it in a transaction, if possible.

Thanks for the help.
Richard Boehme
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]