CRUD Operations in SQLite

This series of tutorials teaches you the basics about CRUD operations (Create - Read - Update - Delete) in SQLite:

• Creating Data
  • INSERT INTO syntax
  • Inserting multiple rows
• Reading Data
  • Basic SELECT statements
  • Filtering with WHERE, BETWEEN, IN, LIKE
  • Sorting results with ORDER BY
• Updating Data
  • UPDATE statements
  • Updating multiple records
• Deleting Data
  • DELETE FROM syntax
  • Truncating tables