Able to perform simple CRUD operations

Question 1

create databse

Answer 1

and use database

Question 2

CREATE (a new record)

Answer 2

Question 3

READ

Answer 3

Reading data:
To retrieve all records from the table:

Question 4

READ a specific columns

Answer 4

To retrieve specific columns:

Question 5

To retrieve a specific record by its primary key

Answer 5

To retrieve a specific record by its primary key (assuming the id is 1):

Question 6

UPDATE

Answer 6

Updating a record:
To update the email of a user with id 1:

Question 7

DELETE

Answer 7

Deleting a record:
To delete a user with id 1: