Skip to main content

Practice ยท 1 of 2

CRUD the Hard Way

Implement setup(conn) that creates table items(id INTEGER PRIMARY KEY, name TEXT NOT NULL, qty INTEGER NOT NULL DEFAULT 0), and restock(conn, name, qty) inserting a row and returning its id.

Difficulty: intermediate

Back to lesson: Practice: SQL Drills