SQL INSERT

Question 1

How do you add a row to a SQL table?

Answer 1

insert into “Table” (“column”)
values (‘whatever’)

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

insert into “Table” (“column”)
values (‘whatever’),
(‘whatever’),
(‘whatever’)

Question 4

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

Answer 4

returning *
or specify what you want to return