"insert or replace" should do it
On Fri, Jan 9, 2009 at 6:21 PM, chiefmccrossan <[email protected]>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 but if
> the column is not empty then I would like to update/overwrite the current
> value in the Name column.
>
> Can anyone please help me?
>
> Thanks
> Adam
> --
> View this message in context:
> http://www.nabble.com/Update-if-exists-or-Insert-if-exists-tp21384054p21384054.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Jim Dodgen
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
