sql-update-insert-delete

Question 1

How do you add a row to a SQL table?

Answer 1

INSERT INTO “table_name” (“col1”, “col2”)
VALUES (“col1val”, “col2val”)

Question 2

What is a tuple?

Answer 2

A tuple is a batch of values surrounded by parenthesis

Question 3

How do you add multiple rows to a SQL table at once?

Answer 3

Using multiple comma separated tuples after the VALUES keyword

Question 4

How do you get back the row being inserted into a table without a separate select statement?

Answer 4

Use RETURNING * or RETURNING “col_names”

Question 5

How do you update rows in a database table?

Answer 5

UPDATE “table_name”
SET “col1” = 100,
“col2” = 40
WHERE “col” = 10;

Question 6

Why is it important to include a where clause in your update statements?

Answer 6

If you dont include a WHERE clause then the entire column will become that value.

Question 7

How do you delete rows from a database table?

Answer 7

DELETE FROM “table_name”
WHERE “col1” = “col1val”

Question 8

How do you accidentally delete all rows from a table?

Answer 8

DELETE FROM “table_name”