1.3.2d SQL

Question 1

How do you insert data into a table using SQL?

Answer 1

INSERT INTO  (field1, field2, field3 , ...)
VALUES ("value1", "value2", "value3", ...)

Question 2

How do you delete records from a database using SQL?

Answer 2

DELETE FROM (tablename)
WHERE (fieldname) = ("condition")

Question 3

How do you update records from a database using SQL?

Answer 3

UPDATE (tablename)
SET (headingY = “value”)
WHERE (headingX = “condition”)

Question 4

How would you select all records that begin with an A?

Answer 4

SELECT (fieldname1, fieldname2, …)
FROM (tablename)
WHERE (fieldname) LIKE A%

Question 5

How would you join 2 tables together?

Answer 5

Use a common fieldname in both tables:
JOIN (fieldname)
ON (1tablename.field = 2tablename.field)
WHERE (tablename.field = “value”)

Question 6

How would you delete a table from SQL?

Answer 6

DROP TABLE (tablename)