Sqlite And Android Insert/updates On Sqlitedatabase -compiledstatements-

Pretend I have a table with 2 columns. _id and name. _id is the primary key and I do not want to set this value manually. I want to perform an insert of name='john,' and let the

Solution 1:

Then

SQLiteStatementstatement= db.compileStatement("INSERT INTO "+TABLENAME+" VALUES(null,?);");
    statement.bindString(1,"john");

Should also work.