Refer link: http://sqlite.org/faq.html#q1
Srikanth On Feb 17, 2:23 pm, 浩翔 <[email protected]> wrote: > I see, I should create table like this: > > db.execute('create table if not exists customers ' + > ' ( ' + > ' id INTEGER PRIMARY KEY > AUTOINCREMENT, ' + > ' first_name varchar(30)' + > ' )'); > > it's no problem ! > > On Feb 17, 5:18 pm, 浩翔 <[email protected]> wrote: > > > I create table like this: > > > db.execute('create table if not exists customers ' + > > ' ( ' + > > ' id int PRIMARY KEY, ' > > + > > ' first_name varchar(30) ' + > > > ' )'); > > > however, when i insert data like this: > > > db.execute("insert into customers('first_name') values (?, ?)", > > ['Monkey!']); > > > I got the result is : > > > id first_name > > null Monkey! > > > id is null ! > > > On Feb 17, 4:54 pm, Alex <[email protected]> wrote: > > > > Hi all, > > > > how to implement id auto increase when i insert a data to gears > > > database(sqlite3) ? > > > > Thanks ! > > > > Alex
