How can I use an autoincrement variable in sqlite?

this is my code in sqlite: stmt.execute("create table if not exists people (name text,ID INTEGER PRIMARY KEY AUTOINCREMENT)");

but when I see my table in Navicat and when I want to use it all of it is null. of want it like integer (1,2,...). What should I do? please help me...