sqlite3 create table auto_increment primary key code example

Example: flutter sqlite auto incrementing id primary key

db.execSQL("create table " + TABLE__WORK + " (ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,Name TEXT, Title TEXT, Time TEXT, Date TEXT)");