Okuzeka
Databases & SQL vocabulary · Database Basics

CRUD

Meaning in databases & SQL, with examples

/krʌd/abbreviationCore term

In databases & SQL, CRUD means: Create, Read, Update, Delete: the four basic operations on stored data, matching the SQL statements INSERT, SELECT, UPDATE and DELETE.

In Turkish: oluşturma, okuma, güncelleme, silme, CRUD

How it is used

Used as an adjective too: 'a CRUD app', 'CRUD screens', 'CRUD endpoints'. It often describes simple business applications whose main job is managing records. In REST APIs the four operations usually map to POST, GET, PUT or PATCH, and DELETE.

Example sentences

  1. Most of the admin panel is simple CRUD for products and categories.

  2. The intern built a CRUD API for the customer table in two days.

Common collocations

  • CRUD operations
  • CRUD app
  • CRUD endpoints
  • basic CRUD
  • INSERT statementThe SQL statement that adds one or more new rows to a table, using INSERT INTO followed by the column names and their values.
  • SELECT statementThe SQL statement that reads data from one or more tables and returns the matching rows without changing anything in the database.
  • UPDATE statementThe SQL statement that changes values in rows that already exist, usually limited by a WHERE clause so that only the right rows are changed.
  • DELETE statementThe SQL statement that removes rows from a table. With a WHERE clause it removes only matching rows; without one it removes every row.
  • ORMObject-relational mapping: a library that lets developers work with database rows as objects in their programming language and generates the SQL for them.

This word in other fields

The same English word can have a different meaning in another field:

More terms: Database Basics

Practise with graded reading

Reading at the right level is the fastest way to make new words stick. Pick free English books by level: