sql-insert

Question 1

How do you add a row to a SQL table?

Answer 1

insert statement,
insert into “table name” (“column name”, “column name”)
values (‘value name’, ‘value name’);

Question 2

What is a tuple?

Answer 2

a list of values

Question 3

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

Answer 3

specify more than one tuple of values, separated by commas.
ex:
values (‘Ostrich Pillow’, ‘Feel comfy!’, 99, ‘self care’),
(‘Tater Mitts’, ‘Scrub some taters!’, 6, ‘cooking’)

Question 4

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

Answer 4

use the returning clause