sql-insert

Question 1

How do you add a row to a SQL table?

Answer 1

Using the “insert into” statement, the table’s name within double quotes, the column’s names within double quotes and parentheses.
Then using the “values” clause, with the values per column within double quote, in respective order, and parentheses per row values.

Question 2

What is a tuple?

Answer 2

List of values.

Question 3

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

Answer 3

By separating the tuples using commas.

Question 4

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

Answer 4

Using “returning” clause followed by the asterisk operator.