# Create, Read, Update, Delete (CRUD)

> The four jobs you do on data: add it, read it, change it, and delete it.

**Field:** Software Development  
**Category:** Databases  
**Also known as:** CRUD, CRUD Operations, CRUD App

## Think of it like

It is like a box of cards. You add a card, read it, fix it, or throw it away.

## Definition

CRUD stands for the four basic jobs you do with stored data: create, read, update and delete. Almost every app does these to its records. A notes app makes a note, shows it, changes it and removes it. In SQL the four jobs are INSERT, SELECT, UPDATE and DELETE. In a web API they are often POST, GET, PUT and DELETE.

## Example

Jack builds a to-do app. Adding a task, listing tasks, ticking one off and removing one are its four CRUD jobs.

## Example code

```sql
INSERT INTO tasks (title) VALUES ('Buy milk');
SELECT * FROM tasks;
UPDATE tasks SET done = true WHERE id = 1;
DELETE FROM tasks WHERE id = 1;
```

Create, read, update and delete, one SQL line each.

## Why it matters

Most apps are CRUD at heart. Once you can do these four jobs, you can build the core of a lot of software.

## Common mistake

Running UPDATE or DELETE with no WHERE. It changes or wipes every row in the table, not just the one you meant.

## Three principles

- **Four jobs.** Create, read, update, delete.
- **Same in many places.** SQL, web APIs and app screens.
- **Aim before you change.** UPDATE and DELETE need a WHERE.

## Related terms

- [Structured Query Language (SQL)](https://learn.benibix.com/term/development/sql)
- [Database](https://learn.benibix.com/term/development/database)
- [REST API](https://learn.benibix.com/term/development/rest-api)
- [SELECT Statement](https://learn.benibix.com/term/development/select-statement)
- [WHERE Clause](https://learn.benibix.com/term/development/where-clause)

![A table with four rows. Each row names one of the four basic jobs and how it is written in SQL and in a web API. Create is INSERT in SQL and POST on the web. Read is SELECT and GET. Update is UPDATE and PUT or PATCH. Delete is DELETE and DELETE.](https://learn.benibix.com/diagrams/dev-crud.svg)

---

Source: https://learn.benibix.com/term/development/crud
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
