INSERT OR REPLACE INTO Employee (id, role, name)
VALUES ( 1,
'code monkey',
(SELECT name FROM Employee WHERE id = 1)
);
ref: https://stackoverflow.com/questions/418898/sqlite-upsert-not-insert-or-replace
INSERT OR REPLACE INTO Employee (id, role, name)
VALUES ( 1,
'code monkey',
(SELECT name FROM Employee WHERE id = 1)
);
ref: https://stackoverflow.com/questions/418898/sqlite-upsert-not-insert-or-replace
本文标题：Upsert in SQLite3
本文链接：https://www.haomeiwen.com/subject/xqfsixtx.html
网友评论