原文: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",...);
原文: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",...);