Create, read, update and delete

Create, read, update, and delete (CRUD) are the four basic operations of persistent storage. The major operations which are implemented by databases are also referred to as CRUD. Each letter in the acronym can be mapped to a standard SQL statement.

CRUD	MariaDB SQL	PostgreSQL	SQLite	REST API
create	insert	insert	insert	post
read	select	select	select	get
update	update	update	update	put
delete	delete	delete	delete	delete