原文:http://stackoverflow.com/questions/3634984/insert-if-not-exists-else-update
insert or replace
例如:
insert or replace into Book (ID,Name,TypeID,Level,Seen) values ((select ID from Book where Name = "SearchName"),"SearchName",...);原文链接:https://www.f2er.com/sqlite/199792.html