Dennis:

Thank you very much for your's Help.

A. J.Millan



----- Original Message ----- 
From: "Dennis Cote" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 06, 2007 11:16 PM
Subject: Re: [sqlite] Newbie SQL question

> >
> Yes. See the documentation for PRAGMA count_changes at
> http://www.sqlite.org/pragma.html.
>
>     SQLite version 3.3.12
>     Enter ".help" for instructions
>     sqlite> create table t (id integer primary key, b text);
>     sqlite> insert into t(b) values('one');
>     sqlite> insert into t(b) values('two');
>     sqlite> insert into t(b) values('three');
>     sqlite> pragma count_changes= 1;
>     sqlite> delete from t where b like 't%';
>     2
>     sqlite> select * from t;
>     1|one
>
>
> HTH
> Dennis Cote
>
> --------------------------------------------------------------------------
---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --------------------------------------------------------------------------
---
>
>


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to