SQLite for Beginners: UPDATE SET WHERE & the Danger of No WHERE | Episode 10

Data changes! In this episode, you learn UPDATE SET WHERE to modify existing rows — one at a time, multiple at once, and the dangerous mistake of forgetting WHERE. We build a student grades database and update grades, rename subjects, and see what happens when you UPDATE without WHERE. Student code: https://github.com/GoCelesteAI/learn-sqlite-in-neovim/tree/main/episode10 Every keystroke is shown on screen with 3-second pauses so you can follow along at your own pace. What You'll Learn: - UPDATE SET WHERE to change specific rows - Updating one row by name - Updating multiple rows by condition - Changing any column with SET - The danger of UPDATE without WHERE - Running SQL files with :!sqlite3 :memory: Timestamps: 0:00 - Introduction 0:12 - Preview: What We Cover 0:44 - Creating update.sql 1:50 - CREATE TABLE students (8 students) 3:05 - INSERT — eight students with grades 5:05 - SELECT * — all students before changes 5:40 - UPDATE one row — Alice B to A 6:21 - UPDATE multiple rows — all C's to B 7:04 - UPDATE column — Science to Physics 7:49 - DANGER: UPDATE without WHERE — all A's! 8:36 - Recap: 3 Key Takeaways 9:10 - End Screen Key Takeaways: 1. UPDATE SET WHERE changes specific rows — always include WHERE 2. WHERE can match one row or many — all matching rows get updated 3. UPDATE without WHERE changes EVERY row — almost always a mistake This is Episode 10 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 #update #set #where #sqlitetutorial #coding Tags sqlite, sqlite tutorial, learn sqlite, sql tutorial, sql for beginners, neovim sqlite, update sql, set where, modify data, neovim tutorial, learn sql in neovim, sql basics, sqlite episode 10, programming tutorial, coding tutorial, beginner programming, sqlite 2026, neovim 2026, screenkey, code along, database tutorial ───────────────────────────────