Hackforge Academy

Explanation

Create operation inserts new records into a table.

Code:

INSERT INTO users(name,email) 
VALUES('Alice','alice@mail.com');

Explanation

Read operation retrieves records from a table.

Code:

SELECT * FROM users;

Explanation

Read with condition filters records.

Code:

SELECT * FROM users WHERE id=1;

Explanation

Update operation modifies existing records.

Code:

UPDATE users SET email='new@mail.com' WHERE id=1;

Explanation

Delete operation removes records from a table.

Code:

DELETE FROM users WHERE id=1;