Learn SQLite in Neovim: Selecting Columns — Pick Only What You Need | Episode 3

Stop using SELECT * for everything! In this episode, you learn to pick specific columns, control output order, and write cleaner queries. We continue with our bookshelf database — same five books, but now we choose exactly which columns to display. Student code: https://github.com/GoCelesteAI/learn-sqlite-in-neovim/tree/main/episode03 Every keystroke is shown on screen with 3-second pauses so you can follow along at your own pace. What You'll Learn: - SELECT with specific column names instead of * - Choosing two columns: title and author - Different column combinations: title and pages - Controlling output column order - Single column queries - Running SQL files with :!sqlite3 Timestamps: 0:00 - Introduction 0:12 - Preview: What We Cover 0:44 - Creating selecting.sql 1:51 - CREATE TABLE and INSERT (5 books) 4:18 - SELECT * — all columns 4:54 - SELECT title, author — two columns 5:37 - SELECT title, pages — different combo 6:21 - SELECT author, title, pages — column order 7:04 - SELECT title — single column 7:42 - Recap: 3 Key Takeaways 8:18 - End Screen Key Takeaways: 1. List column names after SELECT instead of star 2. The output column order matches your SELECT order 3. Select only what you need — smaller output, faster queries This is Episode 3 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 #select #columns #sqlitetutorial #coding Tags sqlite, sqlite tutorial, learn sqlite, sql tutorial, sql for beginners, neovim sqlite, select columns sql, select vs star, column order sql, neovim tutorial, learn sql in neovim, sql basics, sqlite episode 3, programming tutorial, coding tutorial, beginner programming, sqlite 2026, neovim 2026, screenkey, code along, database tutorial