CRUD means Create, Read, Update, Delete. Which SQL commands match these four in that order?
Options
- INSERT, SELECT, UPDATE, DELETE (Correct option)
- SELECT, INSERT, DELETE, UPDATE
- ADD, GET, SET, REMOVE
- MAKE, SHOW, CHANGE, DROP
Answer
INSERT, SELECT, UPDATE, DELETE
Why
Almost every application is built on four basic data operations:
- Create:
INSERT INTO users ... - Read:
SELECT ... FROM users - Update:
UPDATE users SET ... - Delete:
DELETE FROM users WHERE ...
In a REST API they usually map to POST, GET, PUT or PATCH, and DELETE.
Remember
CRUD = INSERT, SELECT, UPDATE, DELETE.