CRUD
CRUD
Create, Read, Update, and Delete are four basic operations of data storage, and are frequently used by SQL and HTTP
- Create
- Create variables and set initial values
- e.g., create variable "hostname" and set the value to "Router1"
- Read
- Retrieve the value of a variable
- e.g., what is the variable "hostname"?
- Update
- Change the value of an existing variable
- e.g., change the value of variable "hostname" to "Router2"
- Delete
- Delete variables
| Operation | SQL | HTTP |
|---|---|---|
| Create | INSERT | POST |
| Read (retrieve) | SELECT | GET |
| Update (modify) | UPDATE | PUT/PATCH |
| Delete (destroy) | DELETE | DELETE |