sql insert

Question 1

How do you add a row to a SQL table?

Answer 1

insert into “table” (“column1”, “column2”, “column3”)

values (‘string’, ‘other string’, 99);

Question 2

What is a tuple?

Answer 2

list of values in SQL, ex: values for an insert statement

Question 3

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

Answer 3

insert into “table” (“column1”, “column2”, “column3”)
values (‘string’, ‘other string’, 99),
(‘string’, ‘other string’, 55);

Question 4

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

Answer 4

insert into “table” (“column1”, “column2”, “column3”)
values (‘string’, ‘other string’, 99)
returning *; // or (list of columns)