On 6/30/2013 11:17 PM, Igor Korot wrote:
On Sun, Jun 30, 2013 at 7:47 PM, Igor Tandetnik <i...@tandetnik.org> wrote:
On 6/30/2013 10:27 PM, Igor Korot wrote:
1. I'm trying to minimize the number of requests I'm doing to the DB. What
I need is a way to count the number of rows that the query return to me
prior to going thru the "sqlite3_step()".
If this number is 0, I want to skip the processing and just return.
How is this different from just calling sqlite3_step, seeing it return
SQLITE_DONE right away, and getting out of the loop?
Well I'm not familiar with SQLite internals, but one thing for sure:
why go thru the process if you can avoid it?
You can't.
Just run this statement;
DELETE FROM players WHERE players.isnew="1";
You are making it way too complicated.
I wish.
I need to remove those records from another table as well.
delete from AnotherTable where playerId in
(select playerid from players where isnew = '1');
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users