SQLite for Beginners: INSERT INTO, Multi-Row Inserts & NULL Values | Episode 2

Learn three ways to add data to your SQLite tables — one row at a time, multiple rows in one statement, and NULL for missing values. We build a bookshelf database with titles, authors, and page counts. By the end, you will know INSERT INTO inside and out. Student code: https://github.com/GoCelesteAI/learn-sqlite-in-neovim/tree/main/episode02 Every keystroke is shown on screen with 3-second pauses so you can follow along at your own pace. What You'll Learn: - INSERT INTO with column names and VALUES - Text in single quotes, numbers without quotes - Inserting multiple rows in one INSERT statement - NULL for missing or unknown data - Running SQL files with :!sqlite3 Timestamps: 0:00 - Introduction 0:12 - Preview: What We Cover 0:44 - Creating inserting.sql 0:54 - File header and dot commands 1:51 - CREATE TABLE books (4 columns) 2:50 - First INSERT — The Hobbit 3:35 - Second and Third INSERTs 4:17 - SELECT * — three books displayed 5:05 - Multi-row INSERT — three more books 5:58 - NULL value — missing page count 6:31 - Final run — six books total 6:55 - Recap: 3 Key Takeaways 7:24 - End Screen Key Takeaways: 1. INSERT INTO adds one row — list column names, then VALUES in parentheses 2. Multi-row INSERT — separate each row with a comma in one statement 3. NULL means missing data — no quotes, it is a keyword This is Episode 2 of the Learn SQLite in Neovim series — 32 episodes from beginner to advanced. Taught by CelesteAI. Like & subscribe for more tutorials! #sqlite #sql #neovim #programming #tutorial #beginners #learnsql #database #insertinto #null #sqlitetutorial #coding Tags sqlite, sqlite tutorial, learn sqlite, sql tutorial, sql for beginners, neovim sqlite, insert into sql, null sql, multi row insert, neovim tutorial, learn sql in neovim, sqlite insert data, sql basics, sqlite episode 2, programming tutorial, coding tutorial, beginner programming, sqlite 2026, neovim 2026, screenkey, code along, database tutorial, sql values