sql-insert

Question 1

How do you add a row to a SQL table?

Answer 1

Using the “insert into” clause followed by the table name surrounded in double quotes, followed by the column name(s) surrounded by double quotes. Then on the next line, use the “values” keyword, followed by the values you want to add in single quotes (in the order of the column names specified on the previous line). Then on the next line, use the “returning” keyword followed by an asterisk if you want to return everything.

insert into (name of table in double quotes) (names of column in double quotes separated by commas and everything surrounded by parentheses)
values (names of values in single quotes separated by commas and everything surrounded by parentheses)
returning *;

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

In the line with the “values” keyword, enter the values you want for each row in its own set of parentheses, with each set of parentheses having its own line and separated by commas.

insert into (name of table in double quotes) (names of column in double quotes separated by commas)
values (names of values in single quotes separated by commas),
(names of values in single quotes separated by commas)
returning *;

Question 4

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

Answer 4

Use the “returning” keyword