The SQL Insert statement in SQLite has some interesting features, such as being able to replace an existing record, just like the Upsert statement in Oracle’s PL/SQL. The expression parameter can either be a literal or the return value from a function. We will explore these interesting features together.
This chapter will demonstrate how to insert data into a SQLite database. I will cover all the supported variations of the API, including:
The data-binding functions
Inserting records
Inserting or replacing records
The Insert or Rollback option
The Insert or Ignore option
The Insert ...
