I just skipped those statements in mail, but i inserted 7 rows. On Wed 16 May, 2018, 4:06 PM Richard Hipp, <[email protected]> wrote:
> On 5/16/18, Sathish Kumar <[email protected]> wrote: > > Hi, > > Please find the below example. > > > > sqlite> create table test (id integer primary key autoincrement, name > > text); > > sqlite> insert into test (name) values('a'); > > sqlite> insert into test (name) values('a'); > > sqlite> select count(*) from test; > > 7 > > How is it that you have 7 rows in the table after only doing 2 INSERTs? > > -- > D. Richard Hipp > [email protected] > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
