Re: [sqlite] How should I get the affected rows' ids

[Igor Tandetnik]

Wu Jian <ravi...@gmail.com> wrote:
> then I exec a SQL like this UPDATE this_table SET data='abc' WHERE id > 2.
>
> OK. We all know that row 3 and row 4 was updated by my SQL. But how should
> my program know that?

What does your program need to know that for? What do you plan to do with this information?

Would a trigger help? http://sqlite.org/lang_createtrigger.html
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite...@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[Kit]

UPDATE this_table SET data='abc' WHERE id > 2;
SELECT id FROM this_table WHERE id > 2;
--
Kit