Re: [sqlite] Re: Auto Increment of Integer Primary Key

2007-08-13 Thread chetana bhargav
To: SQLite Sent: Monday, August 13, 2007 5:31:22 PM Subject: [sqlite] Re: Auto Increment of Integer Primary Key Sreedhar.a wrote: > "create table Test(id integer primary key,player char);" > "insert into Test(id,player) values(2,'surya');" > "insert into Te

[sqlite] Re: Auto Increment of Integer Primary Key

2007-08-13 Thread Igor Tandetnik
Sreedhar.a wrote: "create table Test(id integer primary key,player char);" "insert into Test(id,player) values(2,'surya');" "insert into Test(id,player) values(9223372036854775807,'sree');" "insert into Test(id,player) values(9223372036854775808,'sree1');" "select * from Test;" The result is -