Re: [sqlite] Simple Addition Question

[Martin Engelschalk]

Hello Deepak,

your example is valid SQL. I have tried it and it works in sqlite (of 
course).

Martin

Martin

Deepak Kaul wrote:
I have an addition question.  Is is possible to increment a value in 
an update statement?  If so how would the sql statement be written?

For example
Table addition with the following columns
unique_id, count

I want something like the following
UPDATE addition SET count = count + 1 WHERE unique_id = 1;

Any help would be greatly appreciated.

Thanks in advance