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