AlgoPlus//databases / crud

CRUD & SQL Queries

Watch INSERT, SELECT, UPDATE, and DELETE run row-by-row against a live table.

Statement

—

Operation

—

Rows

0

Affected

—

Legend

Row being scanned

Matches WHERE / SELECT

Inserted

Updated cell

Deleted

AI Tutor Workspace

—

In a nutshell

CRUD is the four things you ever do to stored data — Create, Read, Update, Delete — written in SQL as INSERT, SELECT, UPDATE, DELETE. A table holds rows (records), each with a value in every column; a WHERE clause picks which rows a statement touches. With no index, each statement scans every row.

Ready

Press play to begin the cinematic walkthrough.

A table is rows and columns; the four verbs — INSERT, SELECT, UPDATE, DELETE — create, read, modify, and remove rows. A WHERE clause just filters which rows an operation touches.

Key terms

Go deeper in the lesson

Read the full theory, intuition & complexity for CRUD & SQL Queries.