SQLite Study Notes

Prepare is used to initialize the pre-SQL statement finalize the SQL statement used to release prepare

Reset is used to reset pre-SQL statements for reuse ..

Exec is used to directly execute non-seletc SQL statements. If okstep is returned successfully, it is used to traverse the result set of select in prepare mode. Done is returned successfully.

Sqlite3_step: Correct return value 27 // only sqlite_done is returned. For select queries, if any data returns sqlite_row, 28 // sqlite_done is returned when the result set is reached.

Begin starts a transaction... Commit or rollback ends later