Android SQLite INSERT or REPLACE

Question

I am trying the INSERT OR REPLACE syntax in SQLite with no success so far because no rows are inserted.

My Create table query is

 create table providers (provider_id text not null, provider_name text not null,  provider_channel_id text not null, channel_name text not null);CREATE UNIQUE INDEX channel_id ON providers (provider_channel_id);

My INSERT OR Replace query is

INSERT OR REPLACE INTO providers (provider_channel_id, channel_name, provider_id, provider_name) VALUES ('1', '2', '3', '4')

Thanks

Why you create `provider_id` column but insert into `provider_channel_id` column? — Sieryuu, Sep 01 '12 at 04:49
provider_channel_id is the column on which conflict should be detected, in query columns are quite out of order :) — TilalHusain, Sep 01 '12 at 05:05

score 5 · Answer 1 · answered May 03 '16 at 13:25

5

the solution that i found .replace instead of insert you should also have a row id in the table and set it as PRIMARY KEY

 bdd.replace(table,null, contentValues);

answered May 03 '16 at 13:25

mlika

143
1
7

Android SQLite INSERT or REPLACE

1 Answers1

Linked