CRUD

Question 1

Inserts a new record in the “Customers” table with name as “Darren McBride” and age as 29

Answer 1

INSERT INTO Customers (name, age)

VALUES (“Darren McBride”, 29)

Question 2

Updates the first customer (CustomerID = 1) with a new contact person and a new city

Answer 2

UPDATE Customers
SET ContactName = ‘Alfred Sharpe’, City=’Frankfurt’
WHERE CustomerID = 1

Question 3

Update the contactname to “Juan” for all records where country is “Mexico”

Answer 3

UPDATE Customers
SET ContactName = “Juan”
WHERE Country = “Mexico”

Question 4

Delete the customer “Alfreds Futterkiste” from the “Customers” table

Answer 4

DELETE FROM Customers

WHERE CustomerName = “Alfreds Futterkiste”

Question 5

Delete all rows in the “Customers” table, without deleting the table

Answer 5

DELETE FROM Customers