SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE FileInfo(
  id INTEGER PRIMARY KEY,
  EqpCode TEXT UNIQUE, 
  EqpName TEXT, 
  FileName TEXT
);
✓
INSERT INTO FileInfo(EqpCode, EqpName, FileName) VALUES ('123', 'test00', 'test00')
✓
SELECT * FROM FileInfo;


id
EqpCode
EqpName
FileName


1
123
test00
test00


INSERT INTO FileInfo(EqpCode, EqpName, FileName) VALUES ('123', 'test01', 'test02')
ON CONFLICT(EqpCode) DO UPDATE 
SET EqpName = EXCLUDED.EqpName,
    FileName = EXCLUDED.FileName;
✓
SELECT * FROM FileInfo;


id
EqpCode
EqpName
FileName


1
123
test01
test02