By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE T(
name varchar(50) primary key,
value varchar(50)
);
INSERT INTO T (name,value) Values('secret',"1223");
INSERT INTO T (name,value) Values('secret',"new secret") ON DUPLICATE KEY UPDATE value= VALUES(value);
SELECT * FROM T
| name | value |
|---|---|
| secret | new secret |