Complete CRUD Comparison
text
CREATE
↓
INSERT INTO students
READ
↓
SELECT FROM students
UPDATE
↓
UPDATE students
DELETE
↓
DELETE FROM studentsBooks
text
CREATE
↓
INSERT INTO books
READ
↓
SELECT FROM books
UPDATE
↓
UPDATE books
DELETE
↓
DELETE FROM booksBorrow
text
CREATE
↓
INSERT INTO borrow
READ
↓
SELECT + JOIN
UPDATE
↓
UPDATE borrow
(return book)
DELETE
↓
DELETE FROM borrow
Sign in to save your progress permanently.
Progress is saved in your browser session
Step 6 of 9