SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table t1030 (
  id text not null primary key
, tname text
, tdesc text
, tconfirm bool not null
);
✓
/* 第一次 : 001,aaa,bbb */
REPLACE into t1030 
select '001'
  , 'aaa'
  , 'bbb'
  ,ifnull((
    select true
    from t1030
    where id='001'
    and tname = 'aaa' 
    and tdesc = 'bbb'
    LIMIT 1
  ),false);
✓
select * from t1030
order by id;


id
tname
tdesc
tconfirm


001
aaa
bbb
0


/* 第二次 : 001,aaa,bbb */
REPLACE into t1030 
select '001'
  , 'aaa'
  , 'bbb'
  ,ifnull((
    select true
    from t1030
    where id='001'
    and tname = 'aaa' 
    and tdesc = 'bbb'
    LIMIT 1
  ),false);
✓
select * from t1030
order by id;


id
tname
tdesc
tconfirm


001
aaa
bbb
1


/* 第三次 : 001,aaa,bbb */
REPLACE into t1030 
select '001'
  , 'aaa'
  , 'bbb'
  ,ifnull((
    select true
    from t1030
    where id='001'
    and tname = 'aaa' 
    and tdesc = 'bbb'
    LIMIT 1
  ),false);
✓
select * from t1030
order by id;


id
tname
tdesc
tconfirm


001
aaa
bbb
1


/* 第四次 : 001,ccc,kkk */
REPLACE into t1030 
select '001'
  , 'ccc'
  , 'kkk'
  ,ifnull((
    select true
    from t1030
    where id='001'
    and tname = 'ccc' 
    and tdesc = 'kkk'
    LIMIT 1
  ),false);
✓
select * from t1030
order by id;


id
tname
tdesc
tconfirm


001
ccc
kkk
0


/* 第五次 : 002,ccc,mmm */
REPLACE into t1030 
select '002'
  , 'ccc'
  , 'mmm'
  ,ifnull((
    select true
    from t1030
    where id='002'
    and tname = 'ccc' 
    and tdesc = 'mmm'
    LIMIT 1
  ),false);
✓
select * from t1030
order by id;


id
tname
tdesc
tconfirm


001
ccc
kkk
0

002
ccc
mmm
0