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-...
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