SQL-Insert

Question 1

How do you add a row to a SQL table?

Answer 1

By using the INSERT INTO statement followed by the table name in double quotes. After that a list of comma separated column names within parentheses. On the next line use the VALUES statement followed by a list of comma separated column values within parentheses

Question 2

What is a tuple?

Answer 2

a list of values is referred to as a tuple.

Question 3

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

Answer 3

to add multiple values, you would use the VALUES statement followed by multiple list of values each inside their own set of parentheses

Question 4

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

Answer 4

use the RETURNING statement with an * to return all created rows