Re: [sqlite] Update if exists or Insert if exists

"insert or replace" should do it On Fri, Jan 9, 2009 at 6:21 PM, chiefmccrossan wrote: > > Hi, > > I have a table called Test with one column called Name - CREATE TABLE > "Test" > ("Name" VARCHAR) > > I would like to insert a value into test if the name column is empty

[sqlite] Update if exists or Insert if exists

Hi, I have a table called Test with one column called Name - CREATE TABLE "Test" ("Name" VARCHAR) I would like to insert a value into test if the name column is empty but if the column is not empty then I would like to update/overwrite the current value in the Name column. Can anyone please