sql-insert

Question 1

How do you add a row to a SQL table?

Answer 1

INSERT INTO “tableName” (“nameOfValue”)
VALUES (‘valueData’)

Question 2

What is a tuple?

Answer 2

a tuple is a list of values

Question 3

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

Answer 3

VALUES (‘valueData’), (‘valueData2’)

aka a comma seperated list of tuples

Question 4

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

Answer 4

RETURNING * | or specified column names