SQL

Question 1

how would u only have the field “name” from the table “country” that starts with the letter “D”

Answer 1

SELECT name
FROM country
WHERE name LIKE “D%”

Question 2

how can you insert into a table

Answer 2

INSERT INTO table (field1, field2)
VALUES (value1, value2)

Question 3

how do u delete from a table

Answer 3

DELETE FROM table
WHERE field = condition

Question 4

how do u update a table

Answer 4

UPDATE table
SET field = value
WHERE field = condition